What is the ideal way to update multiple fields within a jsonb column?
For example, if I had the data set
'
{
"field1": true,
"field2": 2,
"field3": "Something",
}
'
How would I update "field2" and "field3". Most questions on StackOverflow seem to be suggesting either a nested jsonb_set call or using the concat operator. Neither one of these solutions seems to be as straight forward as one would expect for updating more than one field in a jsonb column.
Any help is appreciated,
RPiper