Re: Coalesce bug ?

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Re: Coalesce bug ?
Дата
Msg-id CAPTjJmqPnfnc1wK_0e5--WTBDXwWynqFH-7AmK5rT0ByUoWQQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Coalesce bug ?  ("jg" <jg@rilk.com>)
Ответы Re: Coalesce bug ?
Список pgsql-general
On Sat, Dec 22, 2012 at 2:40 AM, jg <jg@rilk.com> wrote:
> Thank you for the documentation link, but it does not help me.

The documentation link states that a function with side effects *must*
to be declared VOLATILE (or if you prefer, *not* declared STRICT or
IMMUTABLE). Emitting warnings is a side effect; you're declaring your
functions IMMUTABLE. According to the documentation, PostgreSQL is
permitted, under the circumstances, to behave any way it likes - up to
and including launching nuclear missiles and unleashing Terminators on
the world.

Does the problem disappear if the functions aren't IMMUTABLE?

ChrisA


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

Предыдущее
От: "David Johnston"
Дата:
Сообщение: Re: Coalesce bug ?
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: Coalesce bug ?