Date: Tue, 18 Feb 2025 15:52:08 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Aleksander Alekseev <aleksander@timescale.com>,
	pgsql-bugs@lists.postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>,
	Chris BSomething <xpusostomos@gmail.com>
Subject: Re: Inconsistency of timezones in postgresql
Message-ID: <Z7Ty-H06PTZr-pgK@momjian.us>
References: 
 <CAJ7c6TNdDV5iE4x7Zw5Ceqt84p97kVYdouWCB4jxYJcyzZpyQg@mail.gmail.com>
 <CADrHaBHn32Ot-vziDQcCvVtjaw9Qd9Kp8A0jYmnEHyiNrffE4g@mail.gmail.com>
 <CAJ7c6TMpU_0NrLMsW0e0TTyfps8TY2g9d5t62kVWkAw_8ARm1Q@mail.gmail.com>
 <CADrHaBE9EykgvqWQnm0wV7eZdzXjS0G+YZNpZxqpqEXXduwQdA@mail.gmail.com>
 <CAJ7c6TME_YvU-zS0Jn1R6LECPvCamG4UToitZw7+0UJdDL+K0g@mail.gmail.com>
 <CADrHaBEV+rAH9samE7cEPv=AGjFj175JT_ncatvYLt4FfyXD6w@mail.gmail.com>
 <CAJ7c6TNrxqZVNx2ob2-x5wMP3WHtyR6xKUZJjNuKFNuHs6XMsA@mail.gmail.com>
 <3384710.1722438948@sss.pgh.pa.us>
 <CAJ7c6TMJJR0ubWxcNG_KhzfE1Q2JUHeWFezgcWUUO=B7KRHjVQ@mail.gmail.com>
 <eb4d1e15c6822c1937be1491118500dd9201492f.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <eb4d1e15c6822c1937be1491118500dd9201492f.camel@cybertec.at>
Archived-At: 
 <https://www.postgresql.org/message-id/Z7Ty-H06PTZr-pgK%40momjian.us>
Precedence: bulk

On Wed, Jan 29, 2025 at 02:09:09PM +0100, Laurenz Albe wrote:
> On Thu, 2024-08-01 at 13:24 +0300, Aleksander Alekseev wrote:
> > > I think this is a documentation issue, specifically that Section 8.5.3
> > > is not sufficiently in-your-face about "UTC+2" not meaning what you
> > > probably think.  We didn't really do anybody any favors by shoving
> > > those details off to Appendix B.
> > 
> > IMO the warning should be placed closer to the documentation for AT
> > TIME ZONE where users have more chances to find it. Here is the patch.
> 
> I think it is odd to have a second set of examples in the documentation
> of AT TIME ZONE.  My attached patch instead adds an example with
> explanation to the already existing examples and a nore to the data
> types section.
> 
> What do you think?

Thanks, patch applied to master.

-- 
  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.