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

From: sunpeng <bluevaley(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Date: 2016-10-13 00:43:32
Message-ID: CAOYKhLrLNU7-vvMNgyJSSJiGhvojgHGyR+MgXAUdptEYAUO8-Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)paquier(at)gmail(dot)com>
wrote:

> On Wed, Oct 12, 2016 at 3:57 PM, sunpeng <bluevaley(at)gmail(dot)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
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-10-13 04:26:49 Re: BUG #14366: jsonb_set() error when modify array element
Previous Message Peter Geoghegan 2016-10-13 00:02:11 Re: BUG #14344: string_agg(DISTINCT ..) crash