Add jsonb_translate(jsonb, from, to)

From: Florents Tselai <florents(dot)tselai(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Add jsonb_translate(jsonb, from, to)
Date: 2025-09-27 17:16:19
Message-ID: CA+v5N41RzrpHVSkeN9EOey0JZbhfS3LB4OsRUD7bzTxrbBAszA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This is a spur of the moment patch really,
but while going through the process of translating some json data from
Greek to English I found myself wishing for $subject.
Inspired by the Unix tr utility.

Here's a working v1

If others find it useful as well,
I'd go ahead with a json implementation
And an additional parameter to make in-arrays replacement optional.

Attachment Content-Type Size
v1-0001-Add-jsonb_translate-function.patch application/x-patch 6.8 KB

Browse pgsql-hackers by date

  From Date Subject
Previous Message Tom Lane 2025-09-27 16:43:49 Re: test_json_parser/002_inline is kind of slow