Horton

isnull or coalesce isn't working

Jochen Schmidt <jochen@joyce.giub.uni-bonn.de>

View thread View on postgr.es
From: Jochen Schmidt <jochen@joyce.giub.uni-bonn.de>
To: pgsql-novice@postgresql.org
Date: 2000-06-04T09:20:17Z
Lists: 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     |  ___/.
.                                                                   | |    .  
............................................................................