Re: Coalesce bug ? - Mailing list pgsql-general

From Chris Angelico
Subject Re: Coalesce bug ?
Date
Msg-id CAPTjJmqPnfnc1wK_0e5--WTBDXwWynqFH-7AmK5rT0ByUoWQQA@mail.gmail.com
Whole thread Raw
In response to Re: Coalesce bug ?  ("jg" <jg@rilk.com>)
Responses Re: Coalesce bug ?
List 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 by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Coalesce bug ?
Next
From: "David Johnston"
Date:
Subject: Re: Coalesce bug ?