MIME-Version: 1.0
References: <202510210803.3b3vfvygxtjl@alvherre.pgsql>
 <3DC56A6A-9525-4C05-B45A-9A135A66BC34@justatheory.com>
 <CACJufxGAmcwq33nr_MmgnGdGo7E10c55kCA22DQ4n9FBUOZmTA@mail.gmail.com>
 <A654130B-16AF-4E37-9D73-B3CDC80C751C@justatheory.com>
 <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>
In-Reply-To: <88a392fd-d732-45a7-bcfc-291258849fbe@dunslane.net>
From: Marcos Pegoraro <marcos@f10.com.br>
Date: Thu, 2 Apr 2026 18:10:59 -0300
Message-ID: 
 <CAB-JLwYmXU0BjPvixZ=shxGAGg6uut9H-RRrOMcN4kda8EwFpQ@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="0000000000003e2b34064e80a558"
Archived-At: 
 <https://www.postgresql.org/message-id/CAB-JLwYmXU0BjPvixZ%3DshxGAGg6uut9H-RRrOMcN4kda8EwFpQ%40mail.gmail.com>
Precedence: bulk

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

Em qui., 2 de abr. de 2026 =C3=A0s 16:22, Andrew Dunstan <andrew@dunslane.n=
et>
escreveu:

> Committed.
>
There is a typo here.
<literal>jsonb_path_query('"xyxtrimyyx"', '$.btrim("xyz")')</literal>
should be
<literal>jsonb_path_query('"xyztrimxyz"', '$.btrim("xyz")')</literal>

regards
Marcos

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

<div dir=3D"ltr"><div dir=3D"ltr"><div>Em qui., 2 de abr. de 2026 =C3=A0s 1=
6:22, Andrew Dunstan &lt;<a href=3D"mailto:andrew@dunslane.net">andrew@duns=
lane.net</a>&gt; escreveu:</div></div><div class=3D"gmail_quote gmail_quote=
_container"><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>Committed.</p></div></blockquote><div><span class=3D"gmail_default" =
style=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">There is a =
typo here.</span>=C2=A0</div><div><span class=3D"gmail_default" style=3D"fo=
nt-family:verdana,sans-serif;color:rgb(102,102,102)">&lt;literal&gt;jsonb_p=
ath_query(&#39;&quot;xyxtrimyyx&quot;&#39;, &#39;$.btrim(&quot;xyz&quot;)&#=
39;)&lt;/literal&gt;</span>=C2=A0</div><div><div class=3D"gmail_default" st=
yle=3D"font-family:verdana,sans-serif;color:rgb(102,102,102)">should be=C2=
=A0</div></div><div><div class=3D"gmail_default" style=3D"font-family:verda=
na,sans-serif;color:rgb(102,102,102)"><span class=3D"gmail_default">&lt;lit=
eral&gt;jsonb_path_query(&#39;&quot;xyztrimxyz&quot;&#39;, &#39;$.btrim(&qu=
ot;xyz&quot;)&#39;)&lt;/literal&gt;</span><span style=3D"font-family:Arial,=
Helvetica,sans-serif;color:rgb(34,34,34)">=C2=A0</span></div><br></div><div=
><div class=3D"gmail_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,sans-serif;color:rgb(102,102,102)">Marcos</div><br></div></d=
iv></div>

--0000000000003e2b34064e80a558--