Re: why are null bytes allowed in JSON columns?

Thanks for the clarification. I now see the "Note" above the table explains this.

Essentially the json data type allows anything that is syntactically valid according to the standard.  That doesn't mean that functions operating on the type can always work, and this is the most obvious of such restrictions.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com