Greg Stark <gsstark(at)mit(dot)edu> 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