Re: Functions and Null Values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Swan <tswan(at)olemiss(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Functions and Null Values
Date: 2000-08-19 03:20:52
Message-ID: 21469.966655252@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thomas Swan <tswan(at)olemiss(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-08-19 05:03:01 Re: Large # of Tables, Getting ready for the enterprise
Previous Message Rini Dutta 2000-08-18 20:55:55 multiple transactions