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 1vDpjs-00HFpH-8b for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Oct 2025 19:52:15 +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 1vDpjq-00EsfJ-Ur for pgsql-hackers@arkaria.postgresql.org; Tue, 28 Oct 2025 19:52:13 +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 1vDpjq-00EsfB-Jf for pgsql-hackers@lists.postgresql.org; Tue, 28 Oct 2025 19:52:13 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vDpjm-004kno-1P for pgsql-hackers@lists.postgresql.org; Tue, 28 Oct 2025 19:52:12 +0000 Received: from phl-compute-05.internal (phl-compute-05.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id ECF79EC0343; Tue, 28 Oct 2025 15:52:07 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Tue, 28 Oct 2025 15:52:07 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=justatheory.com; h=cc:cc:content-type:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to; s=fm2; t=1761681127; x= 1761767527; bh=zF7fGOY5c6TEFZaZPibDytNj+Lg+NaZx7uKvCmTmkHY=; b=G 5nHM0yP6lRmiQujz99Cm5HIx/e/CAoIhPLh3zgAlgZ6YCbgXn0ywtgtLQ1mXnJ06 k7f4NmVnO/rtJVKxxflxiP38V4hCLDlzVovbHlVswJREHJbx5Xu3abvRclc9JMj9 8sMUupKsQtJT6pnjRTA0RbTnx7+9rmU+pzw9wyRAWbc0VBNkMt46MuIZCT2lp7JB 0swbwrzNnW2tG/A7fk0LFPvC4Z6B05tHshkkzPSk0JwcJ8KCypjROtwYV+NFEJiy NalaoSO4pjXHmFahED5xhw6Ke3UFBaUSz4r5n5qCnh/Uq69gfwWzR2AWmKE9uQCl 1ULR/ax/AJNgmwwUj01/g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1761681127; x=1761767527; bh=zF7fGOY5c6TEFZaZPibDytNj+Lg+NaZx7uK vCmTmkHY=; b=DMll9haAjGgayQnT4x+ical87V5Bz5sa2ywRnYghrlOULQLOLHF 0Akl7jI4OJvFP06mq9TrzOElTsxGIlye+JValCD3s7pBuUx6j75AErMDULi2Q3ng pmOf8HeGFyiomxtINiLFx+JQn7JpyEvJ2b3GUE7NwWsa7HpmCzmb8v7MNNVEXtm3 16Q+lbp4OfEHbE3aPDJwqOUckz3f2wDGMc3rfQ/qcatIhvTQtQzlPD8wvhgFuiYa msdo8wUJPudriMd1JAnReR6RqMXbC40aiP7FXIPJjuDXQksDxQ8GCjdDzMayLyHY 3NzrEm4SNDebBNUsvbYMz8P6pRaWnezTkdg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduiedujeegucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurheptggguffhjgffvefkfhfvofesghdtmherhhdtvdenucfhrhhomhepfdffrghvihgu ucfgrdcuhghhvggvlhgvrhdfuceouggrvhhiugesjhhushhtrghthhgvohhrhidrtghomh eqnecuggftrfgrthhtvghrnhepjeegheefgfefjeehgeeghfduhfeffeeileelueetueev fffhkedvueffvdetvdffnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenuc evlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegurghvihgu sehjuhhsthgrthhhvghorhihrdgtohhmpdhnsggprhgtphhtthhopeelpdhmohguvgepsh hmthhpohhuthdprhgtphhtthhopehlihdrvghvrghnrdgthhgrohesghhmrghilhdrtgho mhdprhgtphhtthhopegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdprhgtphhtth hopehflhhorhgvnhhtshdrthhsvghlrghisehgmhgrihhlrdgtohhmpdhrtghpthhtohep thhglhesshhsshdrphhghhdrphgrrdhushdprhgtphhtthhopehpvghtvghrsegvihhsvg hnthhrrghuthdrohhrghdprhgtphhtthhopehrohgsvghrthhmhhgrrghssehgmhgrihhl rdgtohhmpdhrtghpthhtoheprggvkhhorhhothhkohhvsehgmhgrihhlrdgtohhmpdhrtg hpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrphhoshhtghhrvghsqhhl rdhorhhgpdhrtghpthhtoheprghnughrvgifseguuhhnshhlrghnvgdrnhgvth X-ME-Proxy: Feedback-ID: i7c334307:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 28 Oct 2025 15:52:06 -0400 (EDT) Content-Type: multipart/signed; boundary="Apple-Mail=_6FC3765F-353B-439B-96AB-4F6DB4E18250"; protocol="application/pgp-signature"; micalg=pgp-sha256 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.700.81\)) Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part From: "David E. Wheeler" In-Reply-To: <3DC56A6A-9525-4C05-B45A-9A135A66BC34@justatheory.com> Date: Tue, 28 Oct 2025 15:51:55 -0400 Cc: =?utf-8?Q?=C3=81lvaro_Herrera?= , Florents Tselai , Tom Lane , Peter Eisentraut , Robert Haas , Alexander Korotkov , pgsql-hackers , Andrew Dunstan Message-Id: <948630AE-1EF3-42C7-8836-0ED1961DE6F8@justatheory.com> References: <202510210803.3b3vfvygxtjl@alvherre.pgsql> <87530674-E6B6-4C97-A704-78C7E07CF01F@gmail.com> <3DC56A6A-9525-4C05-B45A-9A135A66BC34@justatheory.com> To: Chao Li X-Mailer: Apple Mail (2.3826.700.81) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_6FC3765F-353B-439B-96AB-4F6DB4E18250 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii On Oct 28, 2025, at 15:38, David E. Wheeler = wrote: > This patch uses existing Postgres functions, of which btrim is one[1]. Accidentally cut out my link before sending! [1]: = https://www.postgresql.org/docs/current/functions-string.html#FUNCTIONS-ST= RING D --Apple-Mail=_6FC3765F-353B-439B-96AB-4F6DB4E18250 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+KfmbOQis6ZycGGkt9idPjIgfEFAmkBHtsACgkQkt9idPjI gfHk/A//cZ9wzZTu2s1rXhA1y9vSt6jNvG1itEhv5L23J5ghZufwIt+mnRkUD7WM BOhXAQ1UzC1GadbdXUaEWXTtwk/LPuFJw2xew5UHKsu41pH24rgckCnQ2M95zIvD mVPNgnlR0onmI75TQ5zUGOYryV1aKjApvzrOTFzwEBP2ftb9CfBhfVngTo41HiSh bY3o9ZNS+NjQpHc8QiHxuLEtadh8cIqTSq0+jr66zZhdpGc0xzxk4uT50dtq4fNi 84Vi+GyRGv/0YrHVhh4JeKkgbqL9502ot0Es63hHdkkChIPAAv1jnjQbgZ/n6UX4 23mvYugAq3NKlKoWAUVpInM9qa4AjZZktOt4Tzx2PBUtPSNEQrNGOSCQGyj1BQSf Hlra0fIbNQ8TjFaa0jD5kaqDxGheNEW9wHsm+lOqAsAu5fWyD5TupfcQH8Q0UY9Z 8qupOwZ76UtTBj9M/RpAN3Nq1PeC4NzhRUW9XWms6uiGYYOkmKH0GZLdWo2GifuV StVR3z23J6msu5PVKRicunKe7MyGmFbsPvZ99YEMWD+C6P440hB8XWPNT4X0Ur8L t+dBOxBrbE0hSU/AwXXbTRYP37GDhTBTsV1+F63xN50ceVLZZfVVDNpWa4xndVRh +te/o9p/85no99kWA22i3oNZbPnyIXxByk8Xykd/R0SSsu8I7BA= =VN61 -----END PGP SIGNATURE----- --Apple-Mail=_6FC3765F-353B-439B-96AB-4F6DB4E18250--