4 ms·
Yes, but you don't have to specify all the other columns that aren't being updated. With json/jsonb, you have to provide the entire object graph each time you
by joevandyk 13y ago
Yes, but you don't have to specify all the other columns that aren't being updated.
With json/jsonb, you have to provide the entire object graph each time you are updating it. You can't update one field in the graph. Which could be a pain if you have concurrent updates.
Hopefully we'll be able to update parts of the jsonb columns sometime.
- ants_a 13y agoYou can do it right now, you just need to write your own updating function. With PL/Python or PL/V8 it would be quite simple.