3 ms·
Read somewhere that postgres cannot do in-place json updates. Like you cannot do field->>'val' = 1 in it without updating the whole json. Which becomes relevan
by kapv89 11y ago
Read somewhere that postgres cannot do in-place json updates.
Like you cannot do field->>'val' = 1 in it without updating the whole json.
Which becomes relevant event in moderately write heavy scenarios
- elsurudo 11y agoI think this is possible as of 9.5. See `jsonb_set` here: http://www.postgresql.org/docs/9.5/static/functions-json.html http://www.postgresql.org/docs/9.5/static/functions-json.htm... Not sure how it is implemented, though.
- lobster_johnson 11y ago9.5 adds a bunch of functions for modifying (setting, deleting) nested data.