This is my first email to the PostgreSQL mailing lists so I hope this is the correct place. If not, please let me know.
I was wondering if it would be possible and wise to support JSON Patch? https://tools.ietf.org/html/rfc6902 One of the problems I have as a user is how to update a portion of a JSON object efficiently. Right now I have to read the entire field from the database, update it, and then write it back. I am thinking JSON Patch might be a good way to solve this problem because it would allow partial updates and I think it could easily fit into the existing set of JSON functions such as: // applies a JSON Patch json_patch_apply(json, patch) // diffs two JSON objects and produces a JSON Patch json_patch_diff(json a, json b) Thanks, Ryan Pedela
