| From: | yunlong(dot)gao <yunlong(dot)gao(at)qunar(dot)com> |
|---|---|
| To: | <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: May be a jsonb type bug |
| Date: | 2017-12-25 02:34:48 |
| Message-ID: | e7c6da01-0b39-9030-2ae6-7e7cf053d5bb@qunar.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
--
*PostgreSQL DBA yunlong.gao *
pg开发指南 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=58058230
pg发布流程 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=56215301
pg值班列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=50508626
pg机器列表 http://wiki.corp.qunar.com/pages/viewpage.action?pageId=36438672
pgbouncer http://wiki.corp.qunar.com/display/searchdev/pgbouncer+server
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Sharma | 2017-12-25 07:43:19 | Re: 10.1: hash index size exploding on vacuum full analyze |
| Previous Message | Amit Kapila | 2017-12-23 04:04:27 | Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command. |