Re: Functions used by index don't need to be immutable?

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Functions used by index don't need to be immutable?
Дата
Msg-id aRMviSaBfPzTmMv5@depesz.com
обсуждение исходный текст
Ответ на Re: Functions used by index don't need to be immutable?  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-bugs
On Tue, Nov 11, 2025 at 02:43:18PM +0200, Heikki Linnakangas wrote:
> In case of SQL functions, the immutability check can inline or "see through"
> the definition and determine that the expression used in the function
> doesn't contain any immutable expressions. If you modify get_tsvector,
> adding a random() to it for example, then you will get the error.

Ah, makes sense. Thanks a lot.

Best regards,

depesz




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