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'