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

From yunlong.gao
Subject Re: May be a jsonb type bug
Date
Msg-id e7c6da01-0b39-9030-2ae6-7e7cf053d5bb@qunar.com
Whole thread Raw
In response to Re: May be a jsonb type bug  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-bugs

Thank you very much

在 2017年12月22日 21:04, Sergei Kornilov 写道:
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 accept scalars and objects

Regards, Sergej

pgsql-bugs by date:

Previous
From: Amit Kapila
Date:
Subject: Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with theSHOW command.
Next
From: Ashutosh Sharma
Date:
Subject: Re: 10.1: hash index size exploding on vacuum full analyze