| 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: | Whole Thread | Raw Message | 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
| 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 |