pgsql 更新json数据
update "pce"."p_ttl_data" set val=jsonb_set(val::jsonb,'{AWARDING_STATUS_APPROVAL_STATUS,val}','"Conditional approved"')
WHERE val -> 'AWARDING_STATUS_APPROVAL_STATUS' ->> 'val' = 'Conditional approve'
update "pce"."p_ttl_data" set val=jsonb_set(val::jsonb,'{AWARDING_STATUS_APPROVAL_STATUS,val}','"Conditional approved"')
WHERE val -> 'AWARDING_STATUS_APPROVAL_STATUS' ->> 'val' = 'Conditional approve'