isnull or coalesce isn't working
От | Jochen Schmidt |
---|---|
Тема | isnull or coalesce isn't working |
Дата | |
Msg-id | 200006291358.PAA03520@joyce.giub.uni-bonn.de обсуждение исходный текст |
Список | pgsql-sql |
HI just started using postgres I want to do a select like the following. I have a table with two columns a and b, in b sometimes data are missing. I want to select column b, and if data are missing instead column a as one column in my select. I did: 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. (on my machine: postgresql version 6.4.2) 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-sql по дате отправления: