Horton

Re: why are null bytes allowed in JSON columns?

Andrew Dunstan <andrew@dunslane.net>

View thread
From: Andrew Dunstan <andrew@dunslane.net>
To: Wyatt Alt <wyatt.alt@gmail.com>, "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2023-09-22T21:37:37Z
Lists: pgsql-bugs 
On 2023-09-21 Th 21:57, Wyatt Alt wrote:
> 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