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 1soTON-00BW6G-E0 for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Sep 2024 19:52:44 +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 1soTOM-006y9U-W1 for pgsql-hackers@arkaria.postgresql.org; Wed, 11 Sep 2024 19:52:43 +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 ) id 1soTOM-006y8M-E1 for pgsql-hackers@lists.postgresql.org; Wed, 11 Sep 2024 19:52:42 +0000 Received: from pb-smtp2.pobox.com ([64.147.108.71]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1soTOJ-000gV4-6i for pgsql-hackers@lists.postgresql.org; Wed, 11 Sep 2024 19:52:40 +0000 Received: from pb-smtp2.pobox.com (unknown [127.0.0.1]) by pb-smtp2.pobox.com (Postfix) with ESMTP id BEA12240BC; Wed, 11 Sep 2024 15:52:37 -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= YrIZV2H4vy/BdoF/CUU1qjkKRkIGfxrzuiwchO3fxRE=; b=QTYgcWkE57q7+QHR cotbeF99fomfzeUapj9OzDE/FbP+A80r4E397xGqKAfO2auWDx8i7eJXDszx7oQZ 9RG/ExAyNogE7430fz7grlklu9LQFx4TbixAiREzRXX5GRhdq+Qtq4zAWMqclbQt IXjgeH9xznpvqa9nTLvyYr9SXuc= Received: from pb-smtp2.nyi.icgroup.com (unknown [127.0.0.1]) by pb-smtp2.pobox.com (Postfix) with ESMTP id B5938240BB; Wed, 11 Sep 2024 15:52:37 -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=YrIZV2H4vy/BdoF/CUU1qjkKRkIGfxrzuiwchO3fxRE=; b=YaaSCqdtX1eEHKbf0us2m1Q/K7cWAmfgUw1+g2GlL8EN2w/Frzxs64dp7a5YT4xcy29Y2Sgs4hXRl/1KSBDSO7+FWOII0RDv2izgQiobuW0D5/8XKukosDyxSLOUzNSELCG6uKtSHgXrQ8Bu6XojrYimS3Jf5vWxpevap1TD0u0= 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 1E5FC240BA; Wed, 11 Sep 2024 15:52:37 -0400 (EDT) (envelope-from david@justatheory.com) Content-Type: text/plain; charset=utf-8 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: <3895837.1726083785@sss.pgh.pa.us> Date: Wed, 11 Sep 2024 15:52:26 -0400 Cc: Andrew Dunstan , Peter Eisentraut , jian he , PostgreSQL Hackers Content-Transfer-Encoding: quoted-printable Message-Id: 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> To: Tom Lane X-Mailer: Apple Mail (2.3776.700.51) X-Pobox-Relay-ID: 652D6BCE-7077-11EF-B1AC-9B0F950A682E-76319746!pb-smtp2.pobox.com List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sep 11, 2024, at 15:43, Tom Lane wrote: > Seems to me it should be the jsonpath convention. If the spec > does require any specific spelling, surely it must be that one. WFM, though now I=E2=80=99ll have to go change my port =F0=9F=98=82. D