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 ) id 1sqGh9-008JEo-6Y for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Sep 2024 18:43:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sqGh8-00H3ur-UB for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Sep 2024 18:43:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqGh8-00H3ug-94 for pgsql-hackers@lists.postgresql.org; Mon, 16 Sep 2024 18:43:30 +0000 Received: from pb-smtp2.pobox.com ([64.147.108.71]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sqGh4-001WeZ-Cm for pgsql-hackers@lists.postgresql.org; Mon, 16 Sep 2024 18:43:29 +0000 Received: from pb-smtp2.pobox.com (unknown [127.0.0.1]) by pb-smtp2.pobox.com (Postfix) with ESMTP id BEC533CDE7; Mon, 16 Sep 2024 14:43:24 -0400 (EDT) (envelope-from david@justatheory.com) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=pobox.com; h= content-type:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; s=sasl; bh= iByiQd8dORujay2GUrenMjAetk6ul/FBZEdhYiJPkcE=; b=QStnvM7uMUCP78RU amtcdakzIS4OwQWqdIHqshpANyvFK0oiVIvIZLUVj0E+c9Czs+SwC4Pt49eGn2je 0ihqeW27owcOgbYR84N3ldBZkTMYFsuSMqq9ACsg4psmjbwPfSqquO+EGHXnolKT 1fKx90zIPTDbZUZ+YpMdUqABtF8= Received: from pb-smtp2.nyi.icgroup.com (unknown [127.0.0.1]) by pb-smtp2.pobox.com (Postfix) with ESMTP id B661A3CDE6; Mon, 16 Sep 2024 14:43:24 -0400 (EDT) (envelope-from david@justatheory.com) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=justatheory.com; h=content-type:mime-version:subject:from:in-reply-to:date:cc:content-transfer-encoding:message-id:references:to; s=2016-12.pbsmtp; bh=iByiQd8dORujay2GUrenMjAetk6ul/FBZEdhYiJPkcE=; b=InX88b/jDl+7QpJ89THZzYFM91c+tb6gTkNWY2V9qjVBbaNkVShpSZJf2b14Y+YfOD4gKo0PdIBki++Mp6MEPnIQnNLWy4gA8aAc6ZrA1jjXd5mE/MP/sFZ2Wfvw4LnkBFueFh+Zt4Oy65Kl7R/dm7mt3qxH1qHrMOt8naTnjgY= Received: from smtpclient.apple (unknown [158.222.197.125]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by pb-smtp2.pobox.com (Postfix) with ESMTPSA id 1F41E3CDE5; Mon, 16 Sep 2024 14:43:24 -0400 (EDT) (envelope-from david@justatheory.com) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\)) Subject: Re: Document DateStyle effect on jsonpath string() From: "David E. Wheeler" In-Reply-To: <1221391.1726507795@sss.pgh.pa.us> Date: Mon, 16 Sep 2024 14:43:12 -0400 Cc: Andrew Dunstan , Peter Eisentraut , jian he , PostgreSQL Hackers Content-Transfer-Encoding: 7bit Message-Id: <5F238324-6C69-435A-BCBB-1F520FE0B748@justatheory.com> References: <56955B33-6959-4FDA-A459-F00363ECDFEE@justatheory.com> <4D874C72-8939-4083-8336-AB114D9E29AD@justatheory.com> <3541398.1725994308@sss.pgh.pa.us> <3654686.1725999372@sss.pgh.pa.us> <5e8879d0-a3c8-4be2-950f-d83aa2af953a@eisentraut.org> <3811774.1726063865@sss.pgh.pa.us> <3824427.1726067484@sss.pgh.pa.us> <5801E26B-E2AB-4BA3-8B69-EF8837389284@justatheory.com> <3832087.1726070787@sss.pgh.pa.us> <3835867.1726072002@sss.pgh.pa.us> <3892235.1726081715@sss.pg! ! h.pa.us> <6B388D57-0981-47C3-AD08-7338EE57F0E1@justatheory.com> <3895837.1726083785@sss.pgh.pa.us> <9E6326D3-5965-4619-BAFC-ECD5641B20CD@justatheory.com> <1221391.1726507795@sss.pgh.pa.us> To: Tom Lane X-Mailer: Apple Mail (2.3776.700.51) X-Pobox-Relay-ID: 8DDBB58E-745B-11EF-8FD1-9B0F950A682E-76319746!pb-smtp2.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sep 16, 2024, at 13:29, Tom Lane wrote: > 17.0. If we were already past 17.0 I'd have a lot more angst > about changing this behavior. Great, very glad it made it in. D