Re: [GENERAL] timestamp with time zone output incorrect

2008-04-27 Thread Lew
Steve Martin wrote: Hi, We are having trouble with the output of timestamp with time zone with versions 8.1.10 and 8.3.1. It seems reversed, and change over times are incorrect. timezone for both is: => show timezone ; TimeZone - NZST-12NZDT (1 row) Note, change over times for

Re: [GENERAL] timestamp with time zone output incorrect

2008-04-27 Thread Steve Martin
Tom Lane wrote: Martijn van Oosterhout <[EMAIL PROTECTED]> writes: On Thu, Apr 24, 2008 at 06:30:27PM +1200, Steve Martin wrote: => show timezone ; TimeZone - NZST-12NZDT (1 row) I have no idea what timezone that it. Presumably it switches between daylight s

Re: [GENERAL] timestamp with time zone output incorrect

2008-04-26 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > On Thu, Apr 24, 2008 at 06:30:27PM +1200, Steve Martin wrote: >> => show timezone ; >> TimeZone >> - >> NZST-12NZDT >> (1 row) > I have no idea what timezone that it. Presumably it switches between > daylight savings and non-daylig

Re: [GENERAL] timestamp with time zone output incorrect

2008-04-26 Thread Martijn van Oosterhout
On Thu, Apr 24, 2008 at 06:30:27PM +1200, Steve Martin wrote: > Hi, > > We are having trouble with the output of timestamp with time zone with > versions 8.1.10 and 8.3.1. > It seems reversed, and change over times are incorrect. > > timezone for both is: > => show timezone ; > TimeZone > ---