On 2026-04-03 Fr 7:51 AM, Andrew Dunstan wrote:
On 2026-04-02 Th 5:10 PM, Marcos Pegoraro wrote:
Em qui., 2 de abr. de 2026 às 16:22, Andrew Dunstan
<[email protected]> 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>
Good catch, will fix.
On second thoughts, I don't think this is a typo. btrim() removes
leading and trailing sequences of any characters in the argument string.:
andrew@~=# select jsonb_path_query('"xyxtrimyyx"', '$.btrim("xyz")');
jsonb_path_query
------------------
"trim"
(1 row)
cheers
andrew
--
Andrew Dunstan
EDB:https://www.enterprisedb.com
