Greg Stark <[EMAIL PROTECTED]> writes: > I guess my confusion comes from the way postgres interprets unadorned time > stamps as being in local time. And then always displays timestamps converted > to local time. I thought it was remembering the time zone specified in the > original input. In fact it's not doing that.
Indeed not. (I think that the SQL spec contemplates that TIMESTAMP WITH TIME ZONE *should* work that way, but that's not what we've done.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html