Re: May be a jsonb type bug - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: May be a jsonb type bug
Date
Msg-id 129801513947874@web13g.yandex.ru
Whole thread Raw
In response to May be a jsonb type bug  (yunlong.gao <yunlong.gao@qunar.com>)
Responses Re: May be a jsonb type bug  (yunlong.gao <yunlong.gao@qunar.com>)
List pgsql-bugs
Hi
'null' - is valid JSON document, but not array or object. It is just JSON-null in JSON. (not NULL in terms RDBMS)
Same as '"test"' - is valid JSON-encoded string 'test', '10' - valid JSON int scalar.

jsonb_array_length accept only JSON array documents: '[1,2,3]', '[null, null]', '[]', '[{"n":1}]' and so on and not
acceptscalars and objects
 

Regards, Sergej


pgsql-bugs by date:

Previous
From: yunlong.gao
Date:
Subject: May be a jsonb type bug
Next
From: "Robertson, Alan L"
Date:
Subject: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOWcommand.