Re: [GENERAL] Why extract( ... from timestamp ) is not immutable? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?
Date
Msg-id 22487.1327974077@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
hubert depesz lubaczewski <depesz@depesz.com> writes:
> On Mon, Jan 30, 2012 at 10:35:21AM -0800, Josh Berkus wrote:
>> We can't have functions which are immutable or not depending on their
>> inputs.  That way lies madness.

> but this is exactly what's happening now.

Well, the current marking is clearly incorrect.  What to do about that
is a bit less clear --- should we downgrade the marking, or change the
function's behavior so that it really is immutable?

I haven't formed an opinion on that myself, other than to think that
it's something that requires more than a moment's thought.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: patch for parallel pg_dump
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Speed dblink using alternate libpq tuple storage