Re: Coalesce bug ?

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