isnull or coalesce isn't working
От | Jochen Schmidt |
---|---|
Тема | isnull or coalesce isn't working |
Дата | |
Msg-id | 200006040920.LAA03605@joyce.giub.uni-bonn.de обсуждение исходный текст |
Список | pgsql-novice |
HI just started using postgres I want to do a select like the following. I have a table with two columns a and b, where sometimes data are missing. I want to do: SELECT ifnull(a,b) FROM table; ==>ERROR: No such function 'ifnull' with the specified attributes tried the same thing with isnull and coalesce, same error. help?! thanks, jochen -- ............................................................................ . * . . Dipl. Geogr. Jochen Schmidt * | | . . | | | | . . Department of Geography phone +49/0228/739646 | | | | * . . University of Bonn fax +49/0228/739099 | |_| | | |. . Meckenheimer Allee 166 jochen.schmidt@uni-bonn.de \___ |_| |. . D - 53115 Bonn http://slide.giub.uni-bonn.de/~jochen | ___/. . | | . ............................................................................
В списке pgsql-novice по дате отправления: