postgresql jsonb 拼接

postgresql jsonb 拼接

#替换
select '{"name":"abc"}'::jsonb || '{"name":"aaa"}'::jsonb as name;
      name       
-----------------
 {"name": "aaa"}
(1 row)

#新增 或 合并
select '{"name":"abc"}'::jsonb || '{"age":"18"}'::jsonb as person;
            person            
------------------------------
 {"age": "18", "name": "abc"}
(1 row)

#extend 字段为jsonb类型
update 
	crm.test 
set 
	extend = extend::jsonb || ('{"name":"' || (extend->>'arrive') || '"}')::jsonb 
where 
	id = 1;