Re: [HACKERS] datestyle=postgres broken with timezone=UTC+N

2015-08-30 Thread Christoph Berg
Re: Tom Lane 2015-08-30 <20976.1440946...@sss.pgh.pa.us> > Christoph Berg writes: > > postgres =# set timezone = 'Etc/UTC+1'; > > SET > > postgres =# set datestyle = 'postgres'; > > SET > > postgres =# select '2015-01-01 01:00:00 +0100'::timestamptz; > > Wed 31 Dec 23:00:00 2014 ETC/UTC > > > po

Re: [HACKERS] datestyle=postgres broken with timezone=UTC+N

2015-08-30 Thread Tom Lane
Christoph Berg writes: > postgres =# set timezone = 'Etc/UTC+1'; > SET > postgres =# set datestyle = 'postgres'; > SET > postgres =# select '2015-01-01 01:00:00 +0100'::timestamptz; > Wed 31 Dec 23:00:00 2014 ETC/UTC > postgres =# select 'Wed 31 Dec 23:00:00 2014 ETC/UTC'::timestamptz; > Wed 31

[HACKERS] datestyle=postgres broken with timezone=UTC+N

2015-08-30 Thread Christoph Berg
Discovered when debugging libpqtypes test failures: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=795729 postgres =# set timezone = 'Etc/UTC+1'; SET postgres =# set datestyle = 'postgres'; SET postgres =# select '2015-01-01 01:00:00 +0100'::timestamptz; Wed 31 Dec 23:00:00 2014 ETC/UTC post