Re: Operators based on non-IMMUTABLE functions

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Operators based on non-IMMUTABLE functions
Дата
Msg-id 8960.1236280236@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Operators based on non-IMMUTABLE functions  (Joshua Tolley <eggyknap@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Joshua Tolley <eggyknap@gmail.com> writes:
> I've recently run into a problem with a datatype whose operators are
> based on functions not marked IMMUTABLE. Although there might be good
> reasons to have such a thing, it seems like it might be a valuable
> warning message if you create an operator based on an non-IMMUTABLE
> function. Comments?

No, it wouldn't be a good idea.  There are plenty of such operators.
        regards, tom lane

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Operators based on non-IMMUTABLE functions
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Expanding the length of a VARCHAR column should not induce a table rewrite