Re:PostgreSQL: Jsonb has committed
by arethuza on Monday March 24, 2014 @11:45AM
(#7458853)
It's more they case that when you want to reach into an existing stored document and change a single value you have to re-write the entire document from your application.
On the reading side there are functions and operators that allow you to reach into stored JSON and extract the parts you want. What would be nice would be to be able to do something similar for updates - although this is clearly more complex than reading, so I can see why it has been done this way.
Edit: I guess the most general solution would be to directly support something like JSON Patch:
On the reading side there are functions and operators that allow you to reach into stored JSON and extract the parts you want. What would be nice would be to be able to do something similar for updates - although this is clearly more complex than reading, so I can see why it has been done this way.
Edit: I guess the most general solution would be to directly support something like JSON Patch:
https://tools.ietf.org/html/rfc6902