aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_json_diff
Parameters
Name
Type
Mode
l
jsonb
IN
r
jsonb
IN
Definition
SELECT jsonb_object_agg(a.key, a.value) FROM ( SELECT key, value FROM jsonb_each(l) ) a LEFT OUTER JOIN ( SELECT key, value FROM jsonb_each(r) ) b ON a.key = b.key WHERE a.value != b.value OR b.key IS null;