Re: Constraint exclusion can't process simple constant expressions?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Constraint exclusion can't process simple constant expressions?
Дата
Msg-id 4DAF93EF.5070102@agliodbs.com
обсуждение исходный текст
Ответ на Re: Constraint exclusion can't process simple constant expressions?  (Brendan Jurd <direvus@gmail.com>)
Список pgsql-performance
> You may be thinking of the STABLE volatility level.  It requires that
> the results of the function are the same for the same inputs, within
> the same transaction.

Right.  But CE will only pay attention to immutable values, not stable
ones, AFAICT.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

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

Предыдущее
От: Brendan Jurd
Дата:
Сообщение: Re: Constraint exclusion can't process simple constant expressions?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Constraint exclusion can't process simple constant expressions?