pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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'





view thread (2+ messages)

Message-ID: <1726.980923@bo.nettuno.it>
Permalink:  ../1726.980923@bo.nettuno.it/
Also on:    postgresql.org/message-id/1726.980923@bo.nettuno.it

 · 

reply

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