Postgres Pro
Downloads
Home   >   mailing lists

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 29931.1327509049@sss.pgh.pa.us
Whole thread Raw
Responses Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: [GENERAL] Why extract( ... from timestamp ) is not immutable?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
hubert depesz lubaczewski <depesz@depesz.com> writes:
> anyway - the point is that in \df date_part(, timestamp) says it's
> immutable, while it is not.

Hmm, you're right.  I thought we'd fixed that way back when, but
obviously not.  Or maybe the current behavior of the epoch case
postdates that.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_trigger_depth() v3 (was: TG_DEPTH)
Next
From: Tom Lane
Date:
Subject: Re: GUC_REPORT for protocol tunables was: Re: Optimize binary serialization format of arrays with fixed size elements