public inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Dave Cramer <davecramer@postgres.rocks>
Cc: Robert Treat <rob@xzilla.net>
Cc: Kirk Parker <khp@equatoria.us>
Cc: Richard Neill <rjn@richardneill.org>
Cc: github@richardneill.org
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: Please clarify that Timestamp with Timezone doesn't preserve the timezone.
Date: Thu, 14 May 2026 14:02:15 -0400
Message-ID: <1018713.1778781735@sss.pgh.pa.us> (raw)
In-Reply-To: <agX61I5SYlFJ8pFE@momjian.us>
References: <177685804902.403059.7237129094698721575@wrigleys.postgresql.org>
<agPDkRGXmdyD1EcR@momjian.us>
<ddf41f033a8add84e1f28a095defafae@richardneill.org>
<agR45nws-Y1StCCH@momjian.us>
<CANwZ8rmZdajKmt1KmTRhO7ex-RUeQNwu7yQw19mWaR08B+BdHA@mail.gmail.com>
<agS4qwKSeb-8CrJc@momjian.us>
<CABV9wwPSTVtyBpe8J2kJ1JA29ZKTVtB3+Wjo2gFLJYWZCbqo-Q@mail.gmail.com>
<agW6gzVtz73ZUjNn@momjian.us>
<CADK3HHJ19ewaV3=491dnEsmSS4_KXn1hXGPfwAumQu1YMy++1A@mail.gmail.com>
<agX61I5SYlFJ8pFE@momjian.us>
Bruce Momjian <bruce@momjian.us> writes:
> Okay, here is the patch with "conversion".
timetz does store a UTC offset, so it needs to be discussed separately.
I don't think applying the same verbiage to time and timestamp will
produce anything except more confusion.
regards, tom lane
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, bruce@momjian.us, davecramer@postgres.rocks, rob@xzilla.net, khp@equatoria.us, rjn@richardneill.org, github@richardneill.org, pgsql-docs@lists.postgresql.org
Subject: Re: Please clarify that Timestamp with Timezone doesn't preserve the timezone.
In-Reply-To: <1018713.1778781735@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox