Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part - Mailing list pgsql-hackers

On 2026-04-02 Th 5:10 PM, Marcos Pegoraro wrote:

Em qui., 2 de abr. de 2026 às 16:22, Andrew Dunstan <andrew@dunslane.net> 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