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 > ---

[GENERAL] timestamp with time zone output incorrect

2008-04-26 Thread Steve Martin
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 this year is: Sun