Postgres Pro
Downloads
Home   >   mailing lists

Thread: [BUGS] json and jsonb bug report

[BUGS] json and jsonb bug report

From
Atsushi Ide
Date:
Hi

I found a bug in json and jsonb with null value.

select '{"a":null}'::json;
select '{"a":null}'::jsonb;

it's OK, but followings are returned error.

select '{"a":NULL}'::json;
select '{"a":NULL}'::jsonb;

please fix this bug.
thanks.

Re: [BUGS] json and jsonb bug report

From
"David G. Johnston"
Date:
On Sunday, August 20, 2017, Atsushi Ide <atsushi.530@gmail.com> wrote:
Hi

I found a bug in json and jsonb with null value.

select '{"a":null}'::json;
select '{"a":null}'::jsonb;

it's OK, but followings are returned error.

select '{"a":NULL}'::json;
select '{"a":NULL}'::jsonb;

please fix this bug


 
According to the RFC JSON null is written in all lower case.


Based on that I'd say there is no bug in what you've shown,

David J.