From: Sferacarta Software <sferac@bo.nettuno.it>
To: pgsql-sql@postgresql.org, Colin Dick <cdick@mail.ocis.net>
Cc: pgsql-hackers@postgresql.org
Subject: Re: [SQL] Question re: null
Date: Wed, 23 Sep 1998 17:25:52 +0200
Message-ID: <1726.980923@bo.nettuno.it> (raw)
References: <Pine.LNX.3.96.980922103355.19773A-100000@ocis.ocis.net>
Hello Colin,
martedì, 22 settembre 98, you wrote:
CD> I have written a function that will return an integer based on the length
CD> of a given field defined as text.
CD> It seems that if the given field has not yet been populated (ie: it is
CD> null), my function returns nothing. I have tried expressly sending back a
CD> value as such to no avail:
CD> int isempty(text*)
CD> {
CD> return (100);
CD> }
CD> If the text* is null, it does not return 100 though it does seem to
CD> process the function and does not core dump. (ie: returns blank entries
CD> with the proper number of tuples at the end). Any ideas? Thanks again.
I'm very interesting on this subject too.
Does anybody knows how to solve this question ?
I can't belive that we are the only people having problems
with NULLs. ;)
Jose'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: sferac@bo.nettuno.it, cdick@mail.ocis.net, pgsql-hackers@postgresql.org
Subject: Re: [SQL] Question re: null
In-Reply-To: <1726.980923@bo.nettuno.it>
References: <Pine.LNX.3.96.980922103355.19773A-100000@ocis.ocis.net> <1726.980923@bo.nettuno.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox