Message-ID: <eb4d1e15c6822c1937be1491118500dd9201492f.camel@cybertec.at>
Subject: Re: Inconsistency of timezones in postgresql
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Aleksander Alekseev <aleksander@timescale.com>,
	pgsql-bugs@lists.postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Chris BSomething <xpusostomos@gmail.com>
Date: Wed, 29 Jan 2025 14:09:09 +0100
In-Reply-To: 
 <CAJ7c6TMJJR0ubWxcNG_KhzfE1Q2JUHeWFezgcWUUO=B7KRHjVQ@mail.gmail.com>
References: 
	<CADrHaBFMWsMxGoPBPqY570HSDQZeJ3BtJHhSbUg5LFdErZX6ug@mail.gmail.com>
	 <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>
Content-Type: multipart/mixed; boundary="=-qmJLc6rIXyeoPiHbCQQW"
User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/eb4d1e15c6822c1937be1491118500dd9201492f.camel%40cybertec.at>
Precedence: bulk

--=-qmJLc6rIXyeoPiHbCQQW
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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.=C2=A0 We didn't really do anybody any favors by shoving
> > those details off to Appendix B.
>=20
> 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?

Yours,
Laurenz Albe

--=-qmJLc6rIXyeoPiHbCQQW
Content-Disposition: attachment;
	filename*0=v2-0001-Document-POSIX-time-zone-sign-oddity-more-visibly.pat;
	filename*1=ch
Content-Transfer-Encoding: base64
Content-Type: text/x-patch;
	name="v2-0001-Document-POSIX-time-zone-sign-oddity-more-visibly.patch";
	charset="UTF-8"

RnJvbSAxN2FhZjA3NTcyNzk0MGM1Y2E3ZTdkYzA3NTcyZDY3ZjYwOTM1ODQ2IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h
dD4KRGF0ZTogV2VkLCAyOSBKYW4gMjAyNSAxNDowNTo0NiArMDEwMApTdWJqZWN0OiBbUEFUQ0gg
djJdIERvY3VtZW50IFBPU0lYIHRpbWUgem9uZSBzaWduIG9kZGl0eSBtb3JlIHZpc2libHkKCkFw
cGVuZGl4IEIgYWxyZWFkeSBtZW50aW9uZWQgdGhhdCB0aGUgc2lnbiBvZiB0aGUgdGltZSB6b25l
IG9mZnNldAppbiBQT1NJWCB0aW1lIHpvbmVzIGlzIHRoZSBvcHBvc2l0ZSBvZiB0aGUgbm9ybWFs
IHRpbWUgem9uZSBvZmZzZXQKc2lnbi4gIEhvd2V2ZXIsIHRoaXMgd2FzIHNvbWV3aGF0IGhpZGRl
biwgc28gYWRkIGEgbm90ZSB0byB0aGUKZGF0YSB0eXBlIHNlY3Rpb24gYW5kIGFuIGV4YW1wbGUg
YW5kIGEgcmVmZXJlbmNlIHRvIHRoZSBkb2N1bWVudGF0aW9uCm9mIEFUIFRJTUUgWk9ORS4KUmVw
b3J0ZWQgYnkgQ2hyaXMgQlNvbWV0aGluZy4KCkF1dGhvcjogQWxla3NhbmRlciBBbGVrc2VldgpB
dXRob3I6IExhdXJlbnogQWxiZQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBRHJI
YUJGTVdzTXhHb1BCUHFZNTcwSFNEUVplSjNCdEpIaFNiVWc1TEZkRXJaWDZ1ZyU0MG1haWwuZ21h
aWwuY29tCi0tLQogZG9jL3NyYy9zZ21sL2RhdGF0eXBlLnNnbWwgfCA4ICsrKysrKysrCiBkb2Mv
c3JjL3NnbWwvZnVuYy5zZ21sICAgICB8IDkgKysrKysrKy0tCiAyIGZpbGVzIGNoYW5nZWQsIDE1
IGluc2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9jL3NyYy9zZ21s
L2RhdGF0eXBlLnNnbWwgYi9kb2Mvc3JjL3NnbWwvZGF0YXR5cGUuc2dtbAppbmRleCAxZDkxMjdl
OTRlNC4uNzRjYzRkOGFmY2EgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21s
CisrKyBiL2RvYy9zcmMvc2dtbC9kYXRhdHlwZS5zZ21sCkBAIC0yNjc5LDYgKzI2NzksMTQgQEAg
VElNRVNUQU1QIFdJVEggVElNRSBaT05FICcyMDA0LTEwLTE5IDEwOjIzOjU0KzAyJwogICAgICBz
YXZpbmdzIHdhcyBub21pbmFsbHkgaW4gZWZmZWN0IG9uIHRoYXQgZGF0ZS4KICAgICA8L3BhcmE+
CiAKKyAgICA8bm90ZT4KKyAgICAgPHBhcmE+CisgICAgICBUaGUgc2lnbiBpbiBQT1NJWC1zdHls
ZSB0aW1lIHpvbmUgc3BlY2lmaWNhdGlvbnMgaGFzIHRoZSBvcHBvc2l0ZSBtZWFuaW5nCisgICAg
ICBvZiB0aGUgc2lnbiBpbiBJU08tODYwMSBkYXRldGltZSB2YWx1ZXMuICBGb3IgZXhhbXBsZSwg
dGhlIFBPU0lYIHRpbWUgem9uZQorICAgICAgZm9yIDxsaXRlcmFsPjIwMTQtMDYtMDQgMTI6MDAr
MDQ8L2xpdGVyYWw+IHdvdWxkIGJlIFVUQy00LgorICAgICA8L3BhcmE+CisgICAgPC9ub3RlPgor
CiAgICAgPHBhcmE+CiAgICAgIFRvIGNvbXBsaWNhdGUgbWF0dGVycywgc29tZSBqdXJpc2RpY3Rp
b25zIGhhdmUgdXNlZCB0aGUgc2FtZSB0aW1lem9uZQogICAgICBhYmJyZXZpYXRpb24gdG8gbWVh
biBkaWZmZXJlbnQgVVRDIG9mZnNldHMgYXQgZGlmZmVyZW50IHRpbWVzOyBmb3IKZGlmZiAtLWdp
dCBhL2RvYy9zcmMvc2dtbC9mdW5jLnNnbWwgYi9kb2Mvc3JjL3NnbWwvZnVuYy5zZ21sCmluZGV4
IDU2NzhlNzYyMWE1Li5iNWYyZjIxMDAyNiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2Z1bmMu
c2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZnVuYy5zZ21sCkBAIC0xMDk2OCw2ICsxMDk2OCw4IEBA
IFNFTEVDVCBUSU1FU1RBTVAgJzIwMDEtMDItMTYgMjA6Mzg6NDAnIEFUIFRJTUUgWk9ORSAnQXNp
YS9Ub2t5bycgQVQgVElNRSBaT05FICdBCiA8bGluZWFubm90YXRpb24+UmVzdWx0OiA8L2xpbmVh
bm5vdGF0aW9uPjxjb21wdXRlcm91dHB1dD4yMDAxLTAyLTE2IDA1OjM4OjQwPC9jb21wdXRlcm91
dHB1dD4KIFNFTEVDVCBUSU1FU1RBTVAgV0lUSCBUSU1FIFpPTkUgJzIwMDEtMDItMTYgMjA6Mzg6
NDAtMDUnIEFUIExPQ0FMOwogPGxpbmVhbm5vdGF0aW9uPlJlc3VsdDogPC9saW5lYW5ub3RhdGlv
bj48Y29tcHV0ZXJvdXRwdXQ+MjAwMS0wMi0xNiAxNzozODo0MDwvY29tcHV0ZXJvdXRwdXQ+CitT
RUxFQ1QgVElNRVNUQU1QIFdJVEggVElNRSBaT05FICcyMDAxLTAyLTE2IDIwOjM4OjQwLTA1JyBB
VCBUSU1FIFpPTkUgJyswNSc7Cis8bGluZWFubm90YXRpb24+UmVzdWx0OiA8L2xpbmVhbm5vdGF0
aW9uPjxjb21wdXRlcm91dHB1dD4yMDAxLTAyLTE2IDIwOjM4OjQwPC9jb21wdXRlcm91dHB1dD4K
IFNFTEVDVCBUSU1FIFdJVEggVElNRSBaT05FICcyMDozODo0MC0wNScgQVQgTE9DQUw7CiA8bGlu
ZWFubm90YXRpb24+UmVzdWx0OiA8L2xpbmVhbm5vdGF0aW9uPjxjb21wdXRlcm91dHB1dD4xNzoz
ODo0MDwvY29tcHV0ZXJvdXRwdXQ+CiA8L3NjcmVlbj4KQEAgLTEwOTgwLDExICsxMDk4MiwxNCBA
QCBTRUxFQ1QgVElNRSBXSVRIIFRJTUUgWk9ORSAnMjA6Mzg6NDAtMDUnIEFUIExPQ0FMOwogICAg
IFRva3lvIHRpbWUgdG8gQ2hpY2FnbyB0aW1lLiAgVGhlIGZvdXJ0aCBleGFtcGxlIHNoaWZ0cyB0
aGUgdGltZSBzdGFtcAogICAgIHdpdGggdGltZSB6b25lIHZhbHVlIHRvIHRoZSB0aW1lIHpvbmUg
Y3VycmVudGx5IHNwZWNpZmllZCBieSB0aGUKICAgICA8dmFybmFtZT5UaW1lWm9uZTwvdmFybmFt
ZT4gc2V0dGluZyBhbmQgcmV0dXJucyB0aGUgdmFsdWUgd2l0aG91dCBhCi0gICAgdGltZSB6b25l
LgorICAgIHRpbWUgem9uZS4gIFRoZSBmaWZ0aCBleGFtcGxlIGRlbW9uc3RyYXRlcyB0aGF0IHRo
ZSBzaWduIGluIGEgUE9TSVgtc3R5bGUKKyAgICB0aW1lIHpvbmUgc3BlY2lmaWNhdGlvbiBoYXMg
dGhlIG9wcG9zaXRlIG1lYW5pbmcgb2YgdGhlIHNpZ24gaW4gYW4KKyAgICBJU08tODYwMSBkYXRl
dGltZSBsaXRlcmFsLCBhcyBkZXNjcmliZWQgaW4gPHhyZWYgbGlua2VuZD0iZGF0YXR5cGUtdGlt
ZXpvbmVzIi8+CisgICAgYW5kIDx4cmVmIGxpbmtlbmQ9ImRhdGV0aW1lLWFwcGVuZGl4Ii8+Lgog
ICAgPC9wYXJhPgogCiAgICA8cGFyYT4KLSAgICBUaGUgZmlmdGggZXhhbXBsZSBpcyBhIGNhdXRp
b25hcnkgdGFsZS4gRHVlIHRvIHRoZSBmYWN0IHRoYXQgdGhlcmUgaXMgbm8KKyAgICBUaGUgc2l4
dGggZXhhbXBsZSBpcyBhIGNhdXRpb25hcnkgdGFsZS4gRHVlIHRvIHRoZSBmYWN0IHRoYXQgdGhl
cmUgaXMgbm8KICAgICBkYXRlIGFzc29jaWF0ZWQgd2l0aCB0aGUgaW5wdXQgdmFsdWUsIHRoZSBj
b252ZXJzaW9uIGlzIG1hZGUgdXNpbmcgdGhlCiAgICAgY3VycmVudCBkYXRlIG9mIHRoZSBzZXNz
aW9uLiBUaGVyZWZvcmUsIHRoaXMgc3RhdGljIGV4YW1wbGUgbWF5IHNob3cgYSB3cm9uZwogICAg
IHJlc3VsdCBkZXBlbmRpbmcgb24gdGhlIHRpbWUgb2YgdGhlIHllYXIgaXQgaXMgdmlld2VkIGJl
Y2F1c2UKLS0gCjIuNDguMQoK


--=-qmJLc6rIXyeoPiHbCQQW--