更新时间:2023-02-03 07:50:13
基于 @joonas.fi 和 pozs 的答案,我想出了一个更漂亮"的解决方案
Based on @joonas.fi's and pozs's answers, I came up with a slightly more 'beautiful' solution
UPDATE foo
SET data = jsonb_set(data, '{bar}', (COALESCE(data->>'bar','0')::int + 1)::text::jsonb)
WHERE id = 1;