Postgres Pro
Downloads
Home   >   mailing lists

Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]', - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Date
Msg-id CAB7nPqRjjwgd5RyeUU0tnGf5ugVEZ2es=eSFHJv3n+wDr0Ebcg@mail.gmail.com
Whole thread Raw
In response to 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',  (sunpeng <bluevaley@gmail.com>)
Responses Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
List pgsql-bugs
Tree view 
On Wed, Oct 12, 2016 at 3:57 PM, sunpeng <bluevaley@gmail.com> wrote:
> in 9.6,
> select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',

This is not a complete query, there is no way to guess what is going wrong.

> got:
> [2, null, 3]
> but in 9.6.5, got:
> [[2, 3, 4], 2, null, 3]

9.6.5 has not been released yet, 9.6.X series are currently at 9.6.0.
--
Michael

pgsql-bugs by date:

Previous
From: sunpeng
Date:
Subject: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Next
From: Michael Paquier
Date:
Subject: Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',