Re: More jsonpath methods: translate, split, join

Florents Tselai <florents.tselai@gmail.com>

From: Florents Tselai <florents.tselai@gmail.com>
To: Corey Huinker <corey.huinker@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-06-19T07:19:11Z
Lists: pgsql-hackers

Attachments

On Tue, Jun 16, 2026 at 10:53 PM Corey Huinker <corey.huinker@gmail.com>
wrote:

> On Mon, Apr 13, 2026 at 5:57 AM Florents Tselai <florents.tselai@gmail.com>
> wrote:
>
>> Hello hackers,
>>
>> This is a follow-up to the work recently merged in bd4f879.
>> In hindsight, I regret not pushing these through for the previous cycle,
>> as they represent the "missing pieces" for users trying to perform data
>> cleaning entirely within the JSONPath engine.
>> With these we can significantly reduce the need for users to "drop out"
>> of JSONPath
>> into standard SQL for basic string-to-string-or-array-and-back workflows.
>>
>>
> Seems this one got overlooked, so I took a look. The first patch applies,
> but the second needs a rebase.
>

Thanks for having a look Corey,

here's a consolidated v2 .