| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | German Raul Hoyos Parravicino <rhoyos(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Fwd: Question |
| Date: | 2006-03-07 23:44:55 |
| Message-ID: | 20060307234455.GA36726@winnie.fuhr.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Louis Gonzales | 2006-03-08 06:26:59 | postgresql-8.0.1/Solaris 9/Readline-5.1 |
| Previous Message | German Raul Hoyos Parravicino | 2006-03-07 22:09:56 | Fwd: Question |