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

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: sunpeng <bluevaley(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-12 07:04:02
Message-ID: CAB7nPqRWkjMCaSMJiLHdCOjJS2Z619ON3ObyRWm8COXRJfW7Pw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Oct 12, 2016 at 4: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.

Just saw your other email, I'll reply there directly. Please just
ignore this one.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tillmann Schulz 2016-10-12 10:23:57 Return Codes of BatchUpdateException in PostgreSql 9.6
Previous Message Michael Paquier 2016-10-12 07:00:06 Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',