Re: Document NULL

Well, all comparisons with JSONs runs differently with null values, so maybe an example would help

select f1 = f2 "JS Object Equal - Right",
       f1->'a' = f2->'a' "JS Value Equal - Right",
       f1->>'a' = f2->>'a' "Text Equal - Wrong",
       f1->>'a' IS NOT DISTINCT FROM f2->>'a' "Text Distinct - Right"
from (Values ('{"a": 5}'::jsonb, '{"a": null}'::jsonb)) x(f1,f2)

"JSON values, independently if null or not, are compared using Equal and not Equal operators, so here we don't have the IS DISTINCT operator"

regards

Marcos