Feedback-ID: i7c334307:Fastmail
Content-Type: multipart/signed;
	boundary="Apple-Mail=_1D38C03E-9488-497A-8B6B-C5FA4557B9CA";
	protocol="application/pgp-signature";
	micalg=pgp-sha256
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.600.51.1.1\))
Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim,
 replace, split_part
From: "David E. Wheeler" <david@justatheory.com>
In-Reply-To: 
 <CA+Tgmoa-9tN85bEHfH7TBHa5uV1TwmZJEh_eYkLnwxOV=i6RSg@mail.gmail.com>
Date: Wed, 21 May 2025 14:13:28 -0400
Cc: Florents Tselai <florents.tselai@gmail.com>,
 Alexander Korotkov <aekorotkov@gmail.com>,
 Tom Lane <tgl@sss.pgh.pa.us>,
 pgsql-hackers <pgsql-hackers@lists.postgresql.org>,
 Andrew Dunstan <andrew@dunslane.net>,
 Peter Eisentraut <peter@eisentraut.org>
Message-Id: <6A995806-5B9C-455C-8923-53A0448893BF@justatheory.com>
References: 
 <CA+v5N40sJF39m0v7h=QN86zGp0CUf9F1WKasnZy9nNVj_VhCZQ@mail.gmail.com>
 <145894.1727298237@sss.pgh.pa.us>
 <CAPpHfdtGhn_5jfLoepOScyqT+FXYB9QtV-OEprychDcMJco7mw@mail.gmail.com>
 <CA+v5N42PVJH3HbwLE1yC75XR6E5zGnCCdtSUXfgFwtGyPP8XYg@mail.gmail.com>
 <CA+Tgmob03B6h1SMsi7vs9uOX+vrqg_tyhh--mKC3BaTJ08qKYA@mail.gmail.com>
 <88A95900-E976-43BE-A73A-45AA75A11EE7@justatheory.com>
 <3682F2FE-AB57-4799-A439-7DA518E978A4@gmail.com>
 <F4AB5396-ACCA-4358-969E-6708C7F6A95A@justatheory.com>
 <CA+Tgmoa-9tN85bEHfH7TBHa5uV1TwmZJEh_eYkLnwxOV=i6RSg@mail.gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/6A995806-5B9C-455C-8923-53A0448893BF%40justatheory.com>
Precedence: bulk


--Apple-Mail=_1D38C03E-9488-497A-8B6B-C5FA4557B9CA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

On May 21, 2025, at 14:06, Robert Haas <robertmhaas@gmail.com> wrote:

> No, that wouldn't be too much work, but the issue is that people will
> keep using the _tz versions and when we eventually try to remove them
> those people will complain no matter how prominent we make the
> deprecation notice. If we want to go this route, maybe we should do
> something like:
>=20
> 1. Add the new versions with a _s suffix or whatever.
>=20
> 2. Invent a GUC jsonb_tz_warning =3D { on | off } that advises you to
> use the new functions instead, whenever you use the old ones.
>=20
> 3. After N years, flip the default value from off to on.
>=20
> 4. After M additional years, remove the old functions and the GUC.
>=20
> 5. Still get complaints.

Complainers gonna complain. =F0=9F=AB=A0

Any idea how widespread the use of the function is? It was added in 17, =
and I=E2=80=99ve met few who have really dug into the jonpath stuff yet, =
let alone needed the time zone conversion functionality.

Best,

David


--Apple-Mail=_1D38C03E-9488-497A-8B6B-C5FA4557B9CA
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename=signature.asc
Content-Type: application/pgp-signature;
	name=signature.asc
Content-Description: Message signed with OpenPGP

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEd+KfmbOQis6ZycGGkt9idPjIgfEFAmguF8gACgkQkt9idPjI
gfGhNA//cunqxdm/SX+PTC99tWQd3Z57T0NgRJnfzbAlfxZDb3BfvUdRFVWS6XJJ
g4YqSz8tD6lVBAK1cqSz+datRMbNdIfYNxcCR2fTsjUac/GYESToWs37bxGgZV/l
7VtUwMikFXA/U8noIskPX8CCj6TIy1G5B30BodT08TWlLsmCDThKt1mPCXhk+Rae
gcIJaF0Iy7Q8YzvE22hTqyIi8lYT8IBNKfdNjS+X4U7e1Xp3ZCLxmbIDukjZqjFf
EDcwtgU8HMoVXVMjq2eU2cAIi7fgVYD3DIW+gyNAMZrKXw8eZzkW/cOCJnX8k6qj
jFEnliBCpz6L2ltroDLd4BoxVjmsJUMk0cCTAZ3bjo5DMsjc7WQ8wp1ItxcjhCtv
Gx57Rpm1jhTqe1RJeLLwLscgnWIrFvYxzhbtHK6teGflIQzy2Ju7AbDHHuoAVAYN
ED5hQE9Chub8p0JLhDLA39dmMrh9vN1J8R6F/lfC7QvjWz/fnBoteETYO6eQ+ANg
XtkqGyLlP7//xl1xVxXNht3erfURRE/3wo/Mr3MV62OrJdKd4ys+kVorMBaBEOaW
1Hc67izKYCvcbW6sF8evdCEJ0FdLp9KAEjI82nLy82LWfTiAVGtvRCB7dbiIF/rO
WuQcc9TpdVUfiCGpvBno/10r/tQmYEx38T6ST1HqydGfFHJD2Tg=
=X7hk
-----END PGP SIGNATURE-----

--Apple-Mail=_1D38C03E-9488-497A-8B6B-C5FA4557B9CA--