Re: Functions and Null Values

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Functions and Null Values
Дата
Msg-id 21469.966655252@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Functions and Null Values  (Thomas Swan <tswan@olemiss.edu>)
Список 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 по дате отправления:

Предыдущее
От: Rini Dutta
Дата:
Сообщение: multiple transactions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Large # of Tables, Getting ready for the enterprise