Thread

1. Question re: null

   Colin Dick <cdick@mail.ocis.net> — 1998-09-22T17:37:13Z

   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@mail.ocis.net
   
   
   
   

2. Re: [SQL] Question re: null

   jose' soares <sferac@bo.nettuno.it> — 1998-09-23T15:25:52Z

   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'