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

From sunpeng
Subject Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Date
Msg-id CAOYKhLrLNU7-vvMNgyJSSJiGhvojgHGyR+MgXAUdptEYAUO8-Q@mail.gmail.com
Whole thread Raw
In response to Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
sorry, it's 9.5.4,not 9.6.5.
peng

On Wed, Oct 12, 2016 at 3:00 PM, Michael Paquier <michael.paquier@gmail.com>
wrote:

> 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: Peter Geoghegan
Date:
Subject: Re: BUG #14344: string_agg(DISTINCT ..) crash
Next
From: Tom Lane
Date:
Subject: Re: BUG #14366: jsonb_set() error when modify array element