The syntax in Oracle is "is null" or "is not null" as in: select count(*) from module_master where gatekeeper_status is null; And yes that does work in PostGreSql. Now if your talking about the Oracle function NVL, for Null Value, no that does not work and I don't see a similar function in PostGreSql. You could create one easily enough. Dick Goulet Senior Oracle DBA Oracle Certified DBA -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Michael Fuhr Sent: Tuesday, March 07, 2006 6:45 PM To: German Raul Hoyos Parravicino Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Fwd: Question On Tue, Mar 07, 2006 at 05:09:56PM -0500, German Raul Hoyos Parravicino wrote: > I have a problem developing a ECPG program. I am making a programa using > FETCH, when the second row is sent the following message appear: > > ==>sqlcode [-213] msg[NULL value without indicator in line 1192.] [...] > Is it possible to use something similar to "isnull" in Oracle? Are you looking for the SQL-standard COALESCE? test=> SELECT COALESCE('foo', 'bar'); coalesce ---------- foo (1 row) test=> SELECT COALESCE(NULL, 'bar'); coalesce ---------- bar (1 row) See also the ECPG documentation on using indicators to detect NULL. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
