Received: from joyce.giub.uni-bonn.de (joyce.giub.uni-bonn.de [131.220.125.171]) by hub.org (8.10.1/8.10.1) with ESMTP id e5TDpZ133045 for ; Thu, 29 Jun 2000 09:51:35 -0400 (EDT) Received: (from jochen@localhost) by joyce.giub.uni-bonn.de (8.9.1a/8.9.1) id PAA03520 for pgsql-sql@postgresql.org; Thu, 29 Jun 2000 15:58:22 +0200 (MEST) From: Jochen Schmidt Message-Id: <200006291358.PAA03520@joyce.giub.uni-bonn.de> Subject: isnull or coalesce isn't working To: pgsql-sql@postgresql.org Date: Thu, 29 Jun 2000 15:58:22 +0200 (MEST) X-Mailer: ELM [version 2.5 PL1] MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit X-Archive-Number: 200007/7 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 | ___/. . | | . ............................................................................