Thread

isnull or coalesce isn't working

Jochen Schmidt <jochen@joyce.giub.uni-bonn.de> — 2000-06-29T13:58:22Z

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     |  ___/.
.                                                                   | |    .  
............................................................................