Re: Clearing plans

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Clearing plans
Дата
Msg-id b42b73150701191216q30a67106g8122a1eba09b3d74@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Clearing plans  (Scott Ribe <scott_ribe@killerbytes.com>)
Ответы Re: Clearing plans  (Scott Ribe <scott_ribe@killerbytes.com>)
Список pgsql-general
On 1/19/07, Scott Ribe <scott_ribe@killerbytes.com> wrote:
> > Also, somebody correct me if I'm off my rocker here, but immutable
> > procedures are re-evaluated for each execution...they are just folded
> > into a constant during plan phase.
>
> You would need to actually create an immutable function in order to test how
> immutable functions work ;-) And apparently you can only do that on
> functions that return a value.

d'oh! that was just a transcription error though...if you create f()
returning bigint and immutable it produces the same results.

merlin

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

Предыдущее
От: "Karen Hill"
Дата:
Сообщение: Re: Spam from EnterpriseDB?
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Spam from EnterpriseDB?