Returning NULL from functions - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Returning NULL from functions
Date
Msg-id 3BA94E0F.825B718F@fourpalms.org
Whole thread Raw
Responses Re: Returning NULL from functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I am working on date/time stuff, and in the spirit of cleaning up
interesting but marginally useful features I've dropped support for
"invalid" for the timestamp and timestamptz types. 

To help with upgrading, I thought that I'd map it to a NULL value, and
see the following in the regression tests:

-- Obsolete special values
INSERT INTO TIMESTAMP_TBL VALUES ('invalid');
ERROR:  OidFunctionCall3: function 1150 returned NULL

Is this error message a feature of all returns of NULL, particular to
input routines, or can I somehow mark routines as being allowed to
return NULL values?

Comments?
                       - Thomas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: CVS vs anoncvs (was Re: Case sensitive file names)
Next
From: Tom Lane
Date:
Subject: Re: type casting troubles