> Most notably, 'null'::jsonb = 'null'::jsonb is true whereas NULL = NULL is NUL... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ahachete 9 months ago \| parent \| context \| favorite \| on: What I wish someone told me about Postgres > 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

hibachrach 9 months ago [–]

Right--it makes sense and shouldn't be changed, but it's a bit unintuitive for newcomers.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact