Received: from alcanet.no (ns.alcanet.no [193.213.238.10])
	by hub.org (8.9.3/8.9.3) with ESMTP id FAA60217
	for <docs@postgresql.org>; Wed, 12 May 1999 05:19:26 -0400 (EDT)
	(envelope-from rolf.cohn@alcatel.no)
Received: from alcatel.no ([155.4.4.1]) by ns.alcanet.no with ESMTP id
	<131734>; Wed, 12 May 1999 11:15:03 +0200
Received: from atno70.alcatel.no (atno70.alcatel.no [155.4.8.200])
	by alcatel.no (8.8.8/8.8.8) with ESMTP id LAA31457;
	Wed, 12 May 1999 11:19:21 +0200 (MET DST)
Received: from alcatel.no (atno70.alcatel.no [155.4.8.200])
	by atno70.alcatel.no (8.9.1/8.9.1) with ESMTP id LAA31493;
	Wed, 12 May 1999 11:19:20 +0200 (MET DST)
Sender: Rolf.Cohn@alcatel.no
Message-ID: <37394797.B884C573@alcatel.no>
Date: Wed, 12 May 1999 11:19:19 +0200
From: Rolf Cohn <rolf.cohn@alcatel.no>
X-Mailer: Mozilla 4.5 [en] (X11; I; OSF1 V4.0 alpha)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: linux.postgres
To: docs@postgresql.org
CC: Rolf Cohn <rolf.cohn@alcatel.no>
Subject: Handling of nullable columns in embedded SQL
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello!

How to treat NULL values in queries?


1) Is there an equivalent to the IFNULL (CA-Ingres)/NVL (Oracle)
functions?

Example:
EXEC SQL SELECT IFNULL(foo, -1) FROM bar INTO :dummy;

2) Is it possible to create a host variable
to put the NULL value indicator which then can be checked?

Example:
EXEC SQL SELECT foo FROM bar INTO :dummy_null_ind:dummy;

I have gone through the PostgreSQL Programmer's Guide and
the PostgreSQL User's Guide but did not find the answers.
Did I miss something?


Regards
-- 
vvvvvvvvv --------------------------------------------------------
 vvvvvvv  Rolf Cohn        
  vvvvv   Alcatel Telecom   
   vvv    Norway AS        E-mail: mailto:Rolf.Cohn@alcatel.no
    v -------------------------------------------------------------