Re: Coalesce bug ?

From: Chris Angelico <rosuav(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Coalesce bug ?
Date: 2012-12-21 15:51:46
Message-ID: CAPTjJmqPnfnc1wK_0e5--WTBDXwWynqFH-7AmK5rT0ByUoWQQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Dec 22, 2012 at 2:40 AM, jg <jg(at)rilk(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-12-21 15:55:17 Re: Coalesce bug ?
Previous Message David Johnston 2012-12-21 15:49:15 Re: Coalesce bug ?