Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?

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