Re: stable functions

Поиск
Список
Период
Сортировка
От Filip Rembiałkowski
Тема Re: stable functions
Дата
Msg-id 92869e660705310506j583eb163if315b1edefa9a01f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: stable functions  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Список pgsql-general
2007/5/31, Vincenzo Romano <vincenzo.romano@gmail.com>:

> Nonetheless your remark makes a lot of sense and I'm still in dubt.
> In my case the "creatorfunc" has no parameters and returns void as it reads
> data from configuration tables.
> And it should be OK if ti were run only once.

AFAIK, the only practical sense of defining functions as
stable/immutable is the runtime query optimization.
If you don't need any optimization, and the function takes no params,
why not leave it as volatile?

> I'd say that some more explaination in the documentatio would be great under
> "33.6. Function Volatility Categories".
For me it's clear enough.


--
Filip Rembiałkowski

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

Предыдущее
От: Erwin Brandstetter
Дата:
Сообщение: Re: SELECT from mytbl;
Следующее
От: "Bhavana.Rakesh"
Дата:
Сообщение: Re: jdbc pg_hba.conf error