Re: Functions and Null Values - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Functions and Null Values
Date
Msg-id 21469.966655252@sss.pgh.pa.us
Whole thread Raw
In response to Functions and Null Values  (Thomas Swan <tswan@olemiss.edu>)
List 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


pgsql-hackers by date:

Previous
From: Rini Dutta
Date:
Subject: multiple transactions
Next
From: Tom Lane
Date:
Subject: Re: Large # of Tables, Getting ready for the enterprise