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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general