JSON Merge-Patch

From: Charles Leifer <coleifer(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: JSON Merge-Patch
Date: 2018-12-03 15:07:47
Message-ID: CAPukbqzgC3xz8v93U3TN2RUpkP+Yr4mMer9LFt5aY92V_LZcKQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wanted to request that you all consider implementing a "merge" or
"update" function for performing in-place updates of JSON data-structures.

The relevant algorithm is described here:
https://tools.ietf.org/html/rfc7396

SQLite's json1 extension has an implementation and it's quite useful:
https://www.sqlite.org/cgi/src/artifact/3f017d2659e531d0

For example:

{k1: {x1: y1}} merge {k1: {x2: y2}} -- yields --> {k1 : {x1: y1, x2: y2}}

Thank you for all your work on Postgres. I hope you'll consider adding this
as a built-in function.

Charles

Browse pgsql-hackers by date

  From Date Subject
Next Message didier 2018-12-03 15:40:54 Re: [proposal] Add an option for returning SQLSTATE in psql error message
Previous Message Dilip Kumar 2018-12-03 12:44:57 Re: Undo worker and transaction rollback