On Fri, Mar 27, 2015 at 1:36 PM, Arthur Silva <arthur...@gmail.com> wrote: > On Fri, Mar 27, 2015 at 1:56 PM, Deven Phillips <deven.phill...@gmail.com> > wrote: >> >> Are there any plans or ideas about implement JSON Patch >> (http://jsonpatch.com/) support for PostgreSQL? We deal with some relatively >> large JSON documents for our in-house application and it is often better to >> just send a json-patch update rather than the full document. It would be >> very nice if we could just select for the changes via a trigger and use >> NOTIFY to tell our application about a patch. If nobody has discussed it >> previously, perhaps I will look into implementing it myself. >> >> Thanks in advance, >> >> Deven > > > This could be implemented as an extension. > There're already a few extensions that provide this functionality with plain > functions, so it's just a matter of parsing the json and executing those > functions.
Right. If it was me, I'd shoot for a userland (that is, in sql or pl/pgsql) implementation that wraps the existing json APIs to get the desired result. From there, could determine if a more optimized version in C was warranted. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
