Re: Why extract( ... from timestamp ) is not immutable? - Mailing list pgsql-general

On Wed, Jan 25, 2012 at 08:06:42AM -0800, Adrian Klaver wrote:
> And therein lies the problem:) Per Toms comment, extract sees these timestamps
> without timezones and assumes they are local time and rotates them back to UTC.

i know about it.
but - given the fact that date_part(, timestamp) is marked as immutable,
it seems to be that it's a bug.

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/