| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Dave Cramer <davecramer(at)postgres(dot)rocks>, Robert Treat <rob(at)xzilla(dot)net>, Kirk Parker <khp(at)equatoria(dot)us>, Richard Neill <rjn(at)richardneill(dot)org>, github(at)richardneill(dot)org, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Please clarify that Timestamp with Timezone doesn't preserve the timezone. |
| Date: | 2026-07-21 16:06:31 |
| Message-ID: | al-ZB9ZMNeeUE5fR@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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(at)momjian(dot)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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-07-21 16:48:25 | Re: Add "io worker" as backend_type to the pg_stat_activity documentation |
| Previous Message | Bruce Momjian | 2026-07-21 16:00:01 | Re: Suspected documentation error |