3 ms·
> Most notably, 'null'::jsonb = 'null'::jsonb is true whereas NULL = NULL is NULL Because 'null' in the JSON spec is a literal value (a constant), not SQL's NU
by ahachete 2y ago
> Most notably, 'null'::jsonb = 'null'::jsonb is true whereas NULL = NULL is NULL
Because 'null' in the JSON spec is a literal value (a constant), not SQL's NULL. Nothing to see here.
https://datatracker.ietf.org/doc/html/rfc7159 https://datatracker.ietf.org/doc/html/rfc7159
- hibachrach 2y agoRight--it makes sense and shouldn't be changed, but it's a bit unintuitive for newcomers.