AW: embedded sql with indicators in other DBs

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Michael Meskes'" <meskes(at)postgresql(dot)org>, PostgreSQL Hacker <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: embedded sql with indicators in other DBs
Date: 2000-10-23 09:03:41
Message-ID: 11C1E6749A55D411A9670001FA6879633680C1@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> What do other DBs do with their output variables if there is
> an embedded SQL
> query resulting in a NULL return value? What I mean is:
>
> exec sql select text into :txt:ind from ...
>
> If text is NULL, ind will be set, but does txt change?
>
> I was just told Informix blanks txt.

No, it gives a null string.
In general Informix has a value that represents null that is
'distinct from all legal values in any given datatype'.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2000-10-23 09:30:00 testing my connection to list.
Previous Message Zeugswetter Andreas SB 2000-10-23 08:46:14 AW: relation ### modified while in use