pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Tom Lane <tgl@sss.pgh.pa.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: Tue, 21 Jul 2026 12:06:31 -0400
Message-ID: <al-ZB9ZMNeeUE5fR@momjian.us> (raw)
In-Reply-To: <agYmhgPtEmi2QH_X@momjian.us>
References: <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>
	<1018713.1778781735@sss.pgh.pa.us>
	<agYmhgPtEmi2QH_X@momjian.us>

On Thu, May 14, 2026 at 03:46:14PM -0400, Bruce Momjian wrote:
> On Thu, May 14, 2026 at 02:02:15PM -0400, Tom Lane wrote:
> > 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.
> 
> I see what you mean --- updated patch attached.
> 
> If we want to be more explicit we could change "including time zone
> conversion" to "including time zone conversion to/from UTC".

Applied back to PG 19.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.






view thread (16+ messages)

Message-ID: <al-ZB9ZMNeeUE5fR@momjian.us>
Permalink:  ../al-ZB9ZMNeeUE5fR@momjian.us/
Also on:    postgresql.org/message-id/al-ZB9ZMNeeUE5fR@momjian.us

 · 

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: bruce@momjian.us, tgl@sss.pgh.pa.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: <al-ZB9ZMNeeUE5fR@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox