Request a Demo
Home   >   mailing lists

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

From Andrew Dunstan
Subject Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
Date
Msg-id 88a392fd-d732-45a7-bcfc-291258849fbe@dunslane.net
Whole thread Raw
In response to Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part
List pgsql-hackers
Tree view


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.


cheers


andrew 

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_waldump: support decoding of WAL inside tarfile
Next
From: Tomas Vondra
Date:
Subject: Re: Change default of jit to off