set timezone to 'Australia/Sydney'; set timezone_abbreviations to 'Australia'; set datestyle to 'SQL,DMY'; select '2011-04-03 01:00'::timestamptz+generate_series(0,3)*'1h'::interval,generate_series(0,3); notice how the middle two look the same. (this is Australias DST change-back) This has the potential to cause all sorts of problems, especially in triggers where now() seems to return a string which gets reinterpreted... other than setting datestyle to 'ISO,DMY' is there a way to fix this? How do the Australians handle this? Apparently the zic database (where the string 'EST' originates has been this way since 2004.) select '2011-04-03 02:00:00 EST'::timestamptz - '1h':: interval; -- invariant ? -- ÉÇpun uÊop ÉoÉÉ sÆuÄÊÇÇÉâ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
