Bruce Momjian <br...@momjian.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