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:00:06
Message-ID: CAB7nPqRjjwgd5RyeUU0tnGf5ugVEZ2es=eSFHJv3n+wDr0Ebcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-10-12 07:04:02 Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Previous Message sunpeng 2016-10-12 06:57:11 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',