Re: Functions and Null Values
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Swan <tswan@olemiss.edu>
Cc: pgsql-hackers@postgresql.org
Date: 2000-08-19T03:20:52Z
Lists: pgsql-hackers
Thomas Swan <tswan@olemiss.edu> writes: > From what I can gather the function only gets called when both values are > present and not when any of them are NULL. It's sillier than that: the function does actually get called, and then the return value is thrown away and replaced with a NULL. This is an inherent limitation of the old function-call interface. It is fixed for 7.1 but I don't know of any good workaround for 7.0.* or before. regards, tom lane