Question re: null

From: Colin Dick <cdick(at)mail(dot)ocis(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Question re: null
Date: 1998-09-22 17:37:13
Message-ID: Pine.LNX.3.96.980922103355.19773A-100000@ocis.ocis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

I have written a function that will return an integer based on the length
of a given field defined as text.
It seems that if the given field has not yet been populated (ie: it is
null), my function returns nothing. I have tried expressly sending back a
value as such to no avail:

int isempty(text*)
{
return (100);
}

If the text* is null, it does not return 100 though it does seem to
process the function and does not core dump. (ie: returns blank entries
with the proper number of tuples at the end). Any ideas? Thanks again.

--
Colin Dick
On Call Internet Services
cdick(at)mail(dot)ocis(dot)net

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-09-22 19:20:44 Re: NOT boolfield kills backend
Previous Message Colin Dick 1998-09-22 17:01:30 2 questions.

Browse pgsql-sql by date

  From Date Subject
Next Message Patrick Giagnocavo 1998-09-22 19:53:31 case-insensitive SORT BY?
Previous Message Colin Dick 1998-09-22 17:01:30 2 questions.