Re: Function returning 2 columns evaluated twice when both columns are needed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Function returning 2 columns evaluated twice when both columns are needed
Дата
Msg-id 8522.1255975348@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Function returning 2 columns evaluated twice when both columns are needed  (Gerhard Wiesinger <lists@wiesinger.com>)
Ответы Re: Function returning 2 columns evaluated twice when both columns are needed  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Gerhard Wiesinger <lists@wiesinger.com> writes:
> On Mon, 19 Oct 2009, Tom Lane wrote:
>> Probably because you have the function declared VOLATILE.

> None of the function is declared VOLATILE. Any other idea?

[ shrug... ]  There are other possible reasons why the planner would
fail to flatten a subquery, but none of them apply to the example you
showed.  And your example function *was* VOLATILE, by default.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Function returning 2 columns evaluated twice when both columns are needed
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: autovacuum and immediate shutdown issues