MIME-Version: 1.0
References: <202510210803.3b3vfvygxtjl@alvherre.pgsql>
 <CACJufxEphbmEWLKzYNfzsyEB5+bkbMAMUHJq2LxpDdcSZn98BA@mail.gmail.com>
 <CACJufxGdgxyRLd03wM=GtJzUskXnXxEBGGtwA2vsTvkV827SxA@mail.gmail.com>
 <CACJufxHxWKhNcTsmYz428yxUikeUVZz=o6mLNRXpB7F_1oDEng@mail.gmail.com>
 <CECA8C06-755C-4550-88C8-0E1E0CB03D64@justatheory.com>
 <DB26FD47-DF09-4A92-AA15-08F012ED0DE2@justatheory.com>
 <CA+v5N40aRmC3DYzWDxTbQKMKohkTdMZJ92Nuaj_NniKS7RHpEA@mail.gmail.com>
 <931F201B-FF38-486E-BDEE-DF9692A01E1D@justatheory.com>
 <D81098C5-CB6D-47BE-995B-A451BE396525@justatheory.com>
 <1eb15091-660d-477b-acda-b61d00bc9ffb@dunslane.net>
 <278cb771-6008-44e5-8eaa-9d4acdb56c79@dunslane.net>
 <9E9B3C10-7535-4704-A04A-DF5D32C43DBE@justatheory.com>
 <b3c965ea-89c1-4ef1-a2a9-29854345f96d@dunslane.net>
 <34758556-D3D0-42C3-9A1B-CBF64336ADBC@justatheory.com>
 <88a392fd-d732-45a7-bcfc-291258849fbe@dunslane.net>
 <CAB-JLwYmXU0BjPvixZ=shxGAGg6uut9H-RRrOMcN4kda8EwFpQ@mail.gmail.com>
 <40bd5c82-639d-41cd-ad85-9cd2dffd0680@dunslane.net>
 <df89cceb-d48a-49ee-b54c-d1b1c648b4c5@dunslane.net>
In-Reply-To: <df89cceb-d48a-49ee-b54c-d1b1c648b4c5@dunslane.net>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Fri, 3 Apr 2026 11:34:57 -0300
Message-ID: 
 <CAB-JLwbJEhkdB53yZmn8YxrCHVqWKV7ddr_7vb6ytPA3vKcKxg@mail.gmail.com>
Subject: Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim,
 replace, split_part
To: Andrew Dunstan <andrew@dunslane.net>
Cc: "David E. Wheeler" <david@justatheory.com>,
 Florents Tselai <florents.tselai@gmail.com>,
	pgsql-hackers <pgsql-hackers@lists.postgresql.org>,
 Chao Li <li.evan.chao@gmail.com>,
	=?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>,
	Tom Lane <tgl@sss.pgh.pa.us>, Peter Eisentraut <peter@eisentraut.org>,
	Robert Haas <robertmhaas@gmail.com>,
 Alexander Korotkov <aekorotkov@gmail.com>,
	jian he <jian.universality@gmail.com>
Content-Type: multipart/alternative; boundary="000000000000c112dd064e8f3a8c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwbJEhkdB53yZmn8YxrCHVqWKV7ddr_7vb6ytPA3vKcKxg%40mail.gmail.com>
Precedence: bulk

--000000000000c112dd064e8f3a8c
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Em sex., 3 de abr. de 2026 =C3=A0s 10:36, Andrew Dunstan <andrew@dunslane.n=
et>
escreveu:

> On second thoughts, I don't think this is a typo. btrim() removes leading
> and trailing sequences of any characters in the argument string.
>
Regression has this, so you are correct.
select jsonb_path_query('"zzzytest"', '$.ltrim("xyz")');
 jsonb_path_query
------------------
 "test"

I always thought that only those with exactly the same string would be
removed, but thinking char by char, then it makes perfect sense.
And it works like string trim functions, so everything's fine.
Sorry for the noise.

regards
Marcos

--000000000000c112dd064e8f3a8c
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div>Em sex., 3 de abr. =
de 2026 =C3=A0s 10:36, Andrew Dunstan &lt;<a href=3D"mailto:andrew@dunslane=
.net" target=3D"_blank">andrew@dunslane.net</a>&gt; escreveu:</div></div><d=
iv class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
<u></u>

 =20
   =20
 =20
  <div>
    <p><span class=3D"gmail_default" style=3D"font-family:verdana,sans-seri=
f;color:rgb(102,102,102)"></span>On second thoughts, I don&#39;t think this=
 is a typo. btrim() removes
      leading and trailing sequences of any characters in the argument
      string.</p></div></blockquote><div><span class=3D"gmail_default" styl=
e=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">Regression has =
this, s</span><span style=3D"color:rgb(102,102,102);font-family:verdana,san=
s-serif">o you are correct<span class=3D"gmail_default" style=3D"font-famil=
y:verdana,sans-serif;color:rgb(102,102,102)">.</span></span></div><div><spa=
n class=3D"gmail_default" style=3D"font-family:verdana,sans-serif;color:rgb=
(102,102,102)"></span>select jsonb_path_query<span class=3D"gmail_default" =
style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)"></span>(=
9;&quot;zzzytest&quot;&#39;, &#39;$.ltrim(&quot;xyz&quot;)&#39;);</div>=C2=
=A0jsonb_path_query <br>------------------<br><div>=C2=A0&quot;test&quot;<b=
r></div><div><div class=3D"gmail_default" style=3D"font-family:verdana,sans=
-serif;color:rgb(102,102,102)"><br></div><div class=3D"gmail_default" style=
=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">I always thought=
 that only those with exactly the same string would be removed, but thinkin=
g char by char, then it makes perfect sense.<br>And it works like string=C2=
=A0trim functions, so everything&#39;s fine.=C2=A0</div><div class=3D"gmail=
_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">S=
orry for the noise.</div></div><div class=3D"gmail_default" style=3D"font-f=
amily:verdana,sans-serif;color:rgb(102,102,102)"><br></div><div class=3D"gm=
ail_default" style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)=
">regards</div><div class=3D"gmail_default" style=3D"font-family:verdana,sa=
ns-serif;color:rgb(102,102,102)">Marcos</div></div></div>
</div>

--000000000000c112dd064e8f3a8c--