On Tue, 2025-05-20 at 13:41 +0000, PG Doc comments form wrote:
> Page: https://www.postgresql.org/docs/14/datatype-json.html
> 
> Documentation suggests that a json type of null doesn't turn into anything
> when read into a jsonb, because the json type of null doesn't correspond to
> the postgres type of NULL.  We've found that in fact it's treated the same
> as the string "null" - and the documentation probably should reflect this
> edge case.

I see them treated differently:

SELECT 'null'::jsonb IS NULL;
 ?column? 
══════════
 f
(1 row)

Can you show examples of what you mean?

Yours,
Laurenz Albe


Reply via email to