Re: Incorrect/confusing information about timetz - Mailing list pgsql-docs

From Tom Lane
Subject Re: Incorrect/confusing information about timetz
Date
Msg-id 1757505.1694119308@sss.pgh.pa.us
Whole thread Raw
In response to Re: Incorrect/confusing information about timetz  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Incorrect/confusing information about timetz
List pgsql-docs
Bruce Momjian <bruce@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



pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Incorrect/confusing information about timetz
Next
From: Bruce Momjian
Date:
Subject: Re: Incorrect/confusing information about timetz