特殊类型操作

jsonb

-- 查看元素信息
test=# select * from t_arr where id=4;
 id |                 arr                  
----+--------------------------------------
  4 | {"foo": ["f0032", "f0045", "f0047"]}

--  修改一个元素
update t_arr set arr = jsonb_set(arr,'{foo}',(arr->'foo') - 'f0032') where id=4;