From: Bruce Momjian <bruce@momjian.us>
To: Erik Wienhold <ewie@ewie.name>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: juha.mustonen@iki.fi
Cc: pgsql-docs@postgresql.org
Subject: Re: [DOCS] Add example about date ISO format
Date: Tue, 26 Dec 2023 15:32:23 -0500
Message-ID: <ZYs4V6C4lfSzRcsQ@momjian.us> (raw)
In-Reply-To: <ZXIahHVMT4RlhPFo@momjian.us>
References: <lpj35vsvlgkyuhovitnkoluu2wshd2j6flzpdvuunqezrvgb24@uhskknynuu6l>
<202311271422.j6abzoo2x44p@alvherre.pgsql>
<vjia6do4pkjzccmyo3m2ednylhdrqnqdzgdjz2jk3oxni7ucma@o6zscc2ozujd>
<ZXIahHVMT4RlhPFo@momjian.us>
On Thu, Dec 7, 2023 at 02:18:28PM -0500, Bruce Momjian wrote:
> Yes, there were a few problems with my initial patch. First, I should
> have used "Z" instead of a Z which could be interpreted as a format
> specification; I had already done that for "T" in the example.
>
> Second, I was missing the trailing "Z" in the output --- not sure how
> that happened.
>
> Erik and Alvaro made a great point --- we are using a literal "Z" as the
> time zone output specification, but as Alvaro pointed out, there is no
> way to get the time zone _name_ or even the offset from the AT TIME ZONE
> value, so we must just pass the literal "Z" from the input to the output.
> This proves Alvaro's point on this issue:
>
> SELECT pg_typeof(current_timestamp AT TIME ZONE 'America/Santiago');
> pg_typeof
> -----------------------------
> timestamp without time zone
>
> Updated patch attached. Thank you for the feedback.
Patch applied to master. Thanks for all the suggestions.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
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, ewie@ewie.name, alvherre@alvh.no-ip.org, laurenz.albe@cybertec.at, juha.mustonen@iki.fi
Subject: Re: [DOCS] Add example about date ISO format
In-Reply-To: <ZYs4V6C4lfSzRcsQ@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