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

From Florents Tselai
Subject Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
Date
Msg-id CA+v5N40v=o=ybDcnmYANY535zBa_5CV-yCoFaOShgjU-dq9=zg@mail.gmail.com
Whole thread
In response to Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers



On Thu, Apr 2, 2026 at 10:21 PM Andrew Dunstan <andrew@dunslane.net> wrote:


On 2026-03-28 Sa 11:58 AM, David E. Wheeler wrote:
On Mar 28, 2026, at 11:02, Andrew Dunstan <andrew@dunslane.net> wrote:

The key_name production is what allows a keyword to also be used as an object key in $.keyname syntax. The trim keywords (ltrim, rtrim, btrim) were added there, so $.ltrim as a key works. But $.lower,
$.upper, $.initcap, $.replace, and $.split_part as keys would all break.
Ooh, right. It has been so long since I looked at this stuff that I forgot. Thanks for the reminder.

There are tests added for it.
And for this!



Committed.

Boom! Thanks so much for this.  

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: pgsql: Reduce log level of some logical decoding messages from LOG to D
Next
From: Andres Freund
Date:
Subject: Re: some more include removal from headers