Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Uh, yes to the storage part, no to the output part. ;-) Postgres does
> store the timetz time zone offset, but it doesn't adust it once it is
> stored so doesn't adjust for the session time zone:
Right, it just stores a numeric UTC offset.
> Do we want to document this?
Section 8.5.1.2. Times already says "The appropriate time zone offset
is recorded in the time with time zone value." Maybe that could be
made a little more precise, say "The resolved numeric offset from UTC
is recorded in the time with time zone value."
regards, tom lane