Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1so7JH-008Q67-Tx
	for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Sep 2024 20:18:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1so7JH-001dA6-Ey
	for pgsql-hackers@arkaria.postgresql.org; Tue, 10 Sep 2024 20:17:59 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1so7JH-001d9t-4q
	for pgsql-hackers@lists.postgresql.org; Tue, 10 Sep 2024 20:17:59 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by makus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1so7JE-000WEa-D9
	for pgsql-hackers@lists.postgresql.org; Tue, 10 Sep 2024 20:17:57 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 48AKHsfZ3654857;
	Tue, 10 Sep 2024 16:17:54 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David E. Wheeler" <david@justatheory.com>
cc: jian he <jian.universality@gmail.com>,
        PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Document DateStyle effect on jsonpath string()
In-reply-to: <D6137AEA-0BE7-4328-9718-71B7E6BB4F6C@justatheory.com>
References: <56955B33-6959-4FDA-A459-F00363ECDFEE@justatheory.com> <CACJufxHREyTFzKOWz3f-yD14HxAdfeP1vGQQ2SQrusZ+ziRJyA@mail.gmail.com> <4D874C72-8939-4083-8336-AB114D9E29AD@justatheory.com> <CACJufxHE6q47-GEf3Kk0pD+Snr3yZMM4Byig2=bQKV8js7sP-A@mail.gmail.com> <B8E7081B-A8BE-4BAF-9C6B-AACD4F6EAB00@justatheory.com> <F492B399-37CB-471C-AEAD-25E1C19B607D@justatheory.com> <A556B643-F7E6-442D-9235-2D46A8A887C1@justatheory.com> <3541398.1725994308@sss.pgh.pa.us> <D6137AEA-0BE7-4328-9718-71B7E6BB4F6C@justatheory.com>
Comments: In-reply-to "David E. Wheeler" <david@justatheory.com>
	message dated "Tue, 10 Sep 2024 15:43:09 -0400"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <3654855.1725999474.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Tue, 10 Sep 2024 16:17:54 -0400
Message-ID: <3654856.1725999474@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/3654856.1725999474%40sss.pgh.pa.us>
Precedence: bulk

"David E. Wheeler" <david@justatheory.com> writes:
> On Sep 10, 2024, at 14:51, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Pushed with a little additional polishing.

> Thank you! Do you think it’d be worthwhile to back port to 17?

Not as things stand.  If we adopt Peter's nearby position that
the current behavior is actually buggy, then probably back-patching
a corrected version would be worthwhile as a part of fixing it.

			regards, tom lane