Feedback-ID: i7c334307:Fastmail
Content-Type: multipart/signed;
	boundary="Apple-Mail=_824003EF-00F2-4FC0-A60D-F068BB5786E0";
	protocol="application/pgp-signature";
	micalg=pgp-sha256
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.500.181.1.5\))
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+Tgmob03B6h1SMsi7vs9uOX+vrqg_tyhh--mKC3BaTJ08qKYA@mail.gmail.com>
Date: Tue, 13 May 2025 14:07:10 -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: <88A95900-E976-43BE-A73A-45AA75A11EE7@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>
To: Robert Haas <robertmhaas@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/88A95900-E976-43BE-A73A-45AA75A11EE7%40justatheory.com>
Precedence: bulk


--Apple-Mail=_824003EF-00F2-4FC0-A60D-F068BB5786E0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

On May 9, 2025, at 15:50, Robert Haas <robertmhaas@gmail.com> wrote:

> # We have the kluge of having separate "_tz" functions to support
> # non-immutable datetime operations, but that way doesn't seem like
> # it's going to scale well to multiple sources of mutability.
>=20
> But I'm not sure I understand why it matters that there are multiple
> sources of mutability here. Maybe I'm missing a piece of the puzzle
> here.

I read that to mean =E2=80=9Cwe=E2=80=99re not going to add another =
json_path_exists_* function for every potentially immutable JSONPath =
function. But I take your point that it could be generalized for *any* =
mutable function. In which case maybe it should be renamed?

Best,

David


--Apple-Mail=_824003EF-00F2-4FC0-A60D-F068BB5786E0
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+KfmbOQis6ZycGGkt9idPjIgfEFAmgjik4ACgkQkt9idPjI
gfHhdQ//YKYh37AV8r90skSWJcNnl9OddrStBMptOHbz8gFldnHvH/MFfjO6Tx9T
HgF2eTWlvifm+zmfKKHQfwKWoYaL/9LaU5/s4ATUJr0/Iz/P5L6i8M05LCGiwPoR
3iYzXlg02axa/+QJDWbYMsYwYpsJpcvaCxdLBGEbIAgafJ0zrbdoCVg9CNxwgTYZ
R/oDinVIsaAiuejUCQN/dKhYmG527ORDSYXOEOcJlFsfOj+Jh0jOh2ZI8gIXP9/K
zaZy6SbKDZtCh0EpBCE2ifWfs3S/imdv0NMOGXuXqYj06hTgmSY88ymdktYOBiUu
1RAuRGPXbPHRaQv7DesLTgZSZnpNPgU4xEBvihHdtSJNJuQJEqhxKPNl4GtpuwJ4
YmnVa+zqb4CLhOGlX7oE2DIKG5EMgw9IYfVEt8zNI4nLI32kxnInCGnb9k6neyKr
G7TQIYd1cOYRFlwBN8yygAxtrO+BYmVqLiGZGD3q21SWGw4e7hMEuy++VmdzLLXm
1lcJOop70wO0vpjmf5nTeQ3QJsf7t7LvxS8z/Nrc8eO4rqHsBgA/dcFEL4zYBZ59
AVZ2BRvt3qYEwHJ+o75HSQ8FMNGXp+bSfirJHFeKe8+jTaME1qj+XI3AQ54uOZs6
yKFQx2x7B1gQ1h6nz6ZfvFfJ96/RMpjqHzGeefc5RF/vZ+kZFyg=
=A9ph
-----END PGP SIGNATURE-----

--Apple-Mail=_824003EF-00F2-4FC0-A60D-F068BB5786E0--