Re: May be a jsonb type bug

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: yunlong(dot)gao <yunlong(dot)gao(at)qunar(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: May be a jsonb type bug
Date: 2017-12-22 13:04:34
Message-ID: 129801513947874@web13g.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 accept scalars and objects

Regards, Sergej

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Robertson, Alan L 2017-12-22 16:18:09 ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command.
Previous Message yunlong.gao 2017-12-22 12:43:19 May be a jsonb type bug