On Wed, 7 Nov 2007, Tom Lane wrote: > Nick Johnson <ctfdy@xxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
