On Tue, Jan 11, 2005 at 07:44:46PM -0500, Tom Lane wrote: > David Fetter <david@xxxxxxxxxx> writes: > >> The recommended locution is > >> > >> SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second'; > > > I think this should read: > > > SELECT TIMESTAMP WITH TIME ZONE 'epoch' AT TIME ZONE 'UTC' + <x> * INTERVAL '1 second'; > > /* ^^^^^^^^^^^^^^^^^^ */ > > It's correct as written; your modification throws it off by the > local GMT offset. Thanks for the heads-up. I was just about to Do The Wrong Thing(TM) in a doc patch re: ALTER COLUMN TYPE :) Cheers, D -- David Fetter david@xxxxxxxxxx http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
