Re: strange timezone problem - Mailing list pgsql-general

From Nick Johnson
Subject Re: strange timezone problem
Date
Msg-id 20071107092324.Y46367@turing
Whole thread Raw
In response to Re: strange timezone problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 7 Nov 2007, Tom Lane wrote:

> Nick Johnson <ctfdy@spatula.net> writes:
> > I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:

[snip]

> > Shouldn't that second row have been in the results of the second query?
>
> Huh?  Those results look perfectly sane to me.

Ah, you're right of course.  Just a complete mental lapse on my part (thus
the need of a 'sanity' check).

> That's correct ... as of last year, DST extends through the first Sunday
> in November in the USA.

Twice in one morning the database was cleverer than me.

   Nick


pgsql-general by date:

Previous
From: andy
Date:
Subject: Re: strange timezone problem
Next
From: "Gauthier, Dave"
Date:
Subject: Re: DB on a ramdisk (was Re: Temporary, In-memory Postgres DB?)