Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.8.8/8.8.8) with ESMTP id LAA17098; Wed, 23 Sep 1998 11:25:55 -0400 (EDT) (envelope-from sferac@bo.nettuno.it) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.8.6/8.8.6/NETTuno 3.1) with ESMTP id RAA13756; Wed, 23 Sep 1998 17:25:42 +0200 (MDT) Received: from blu.sferacarta.com (mail.sferacarta.com) [10.20.30.12] by proxy.sferacarta.com with smtp (Exim 1.92 #1 (Debian)) id 0zLsZE-0003SR-00; Wed, 23 Sep 1998 17:19:04 +0000 Date: Wed, 23 Sep 1998 17:25:52 +0200 From: Sferacarta Software X-Mailer: The Bat! (v1.017) UNREG Reply-To: Sferacarta Software Organization: Sferacarta Software Priority: Normal Message-ID: <1726.980923@bo.nettuno.it> To: pgsql-sql@postgresql.org, Colin Dick CC: pgsql-hackers@postgresql.org Subject: Re: [SQL] Question re: null References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit 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'