我正在尝试更新json
[{"id": "1","name": "myconf","icons": "small","theme": "light","textsize": "large"},{"id": 2,"name": "myconf2","theme": "dark"},{"name": "firstconf","theme": "dark",{"id": 3,"name": "firstconxsf","theme": "dassrk","textsize": "lassrge"}]
这是包含该json列的表:
CREATE TABLE USER_CONFIGURATIONS ( ID BIGSERIAL PRIMARY KEY,DATA JSONB );
我正在使用添加新字段很容易:
UPDATE USER_CONFIGURATIONS
SET DATA = DATA || '{"name":"firstconxsf","theme":"dassrk","textsize":"lassrge"}'
WHERE id = 9;
但是如何用id = 1或2更新单次