Feedback-ID: i7c334307:Fastmail
Content-Type: multipart/signed;
	boundary="Apple-Mail=_DF95660A-D3FE-4BE9-9F88-8139A684483C";
	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: <9E77459B-0E6D-4105-A8D9-E5AED5F0AC0B@gmail.com>
Date: Thu, 22 May 2025 14:08:02 -0400
Cc: Robert Haas <robertmhaas@gmail.com>,
 Tom Lane <tgl@sss.pgh.pa.us>,
 Alexander Korotkov <aekorotkov@gmail.com>,
 pgsql-hackers <pgsql-hackers@lists.postgresql.org>,
 Andrew Dunstan <andrew@dunslane.net>,
 Peter Eisentraut <peter@eisentraut.org>
Message-Id: <33601D2F-6BCA-4E6C-AC97-668A739356F8@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>
 <6A995806-5B9C-455C-8923-53A0448893BF@justatheory.com>
 <1303509.1747852287@sss.pgh.pa.us>
 <CA+Tgmoae0B0ax=ScZyziW7xm6f3v3ciNNZiZW0gZBqZnm2AHUQ@mail.gmail.com>
 <9E77459B-0E6D-4105-A8D9-E5AED5F0AC0B@gmail.com>
To: Florents Tselai <florents.tselai@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/33601D2F-6BCA-4E6C-AC97-668A739356F8%40justatheory.com>
Precedence: bulk


--Apple-Mail=_DF95660A-D3FE-4BE9-9F88-8139A684483C
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8

On May 22, 2025, at 12:38, Florents Tselai <florents.tselai@gmail.com> =
wrote:

> In my experience timestamp related stuff from jsonb documents end up =
in a generated column,
> and are indexed & queried there.

Have you seen this in the wild using the _tz functions? I wouldn=E2=80=99t=
 think they were indexable, given the volatility.

D


--Apple-Mail=_DF95660A-D3FE-4BE9-9F88-8139A684483C
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+KfmbOQis6ZycGGkt9idPjIgfEFAmgvaAIACgkQkt9idPjI
gfG1vw/9ErmvZC8FJzsGTfAACY7rcURmnHVUdsuH32hPlvtXX6+bJzZRZjXXBWQ8
+ZxIXSwj/7eTikSzk2vxxcmNhwevbcKgxr2uwbcba1ACFDAMoRVphN2fhb/shHAt
YOySaIvVcgkl5Jeh/fv/SFCWaor3Y9Kb7WcFQauI+bs7kLUo3PmiUgu4Z9+PBeFR
aTz5/3vbNFhWRQb9olHnaSyy44YZ2bAsB+ORFnB3nO/iygpXjXGHC02moXY4rR3R
yyGnzLin30pqwZxr72qM8k/bTEghHMzy/vj0eDxiOSPJZufwX6G3Dq5E7R3Dzeb9
8E8RTt6pj7ifi/Zr3txpSDT0ifVnvVmOgKZIt53cbsnkt2e4XKXrrbCrjoPF4yYu
soW1IINX86x8yYa/URaECRCoyw6w/2LnzW7rK2VbVPn6q7Nr9MAtv8mmYuxJMNqM
IM6rC66VvyGZWbxlJbQ2VJYUVkallWMFAxSk0+gnCO+FIhCa4lDaWC+Fup2zrwff
ARGwctLaDUqf7sNHMu0KxdcAPOiH402YXOnpJIeYqmbk9xEVROalWBzW1uKV4Zfm
4TWZKhyiaeEfsmt6+gH8rDJYPcJUqZj1CMw3JTd0anDn1KJi/+kjZl7RM1YJ8a4Y
olGnFw30rDzjbxNtK+CzW9B/CCQ7bbYdqUM15ez+qPhfoYV3MWo=
=jrUM
-----END PGP SIGNATURE-----

--Apple-Mail=_DF95660A-D3FE-4BE9-9F88-8139A684483C--