Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #14366: jsonb_set() error when modify array element - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14366: jsonb_set() error when modify array element
Date
Msg-id 1269.1476332809@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14366: jsonb_set() error when modify array element  (bluevaley@gmail.com)
Responses Re: BUG #14366: jsonb_set() error when modify array element
List pgsql-bugs
Tree view 
bluevaley@gmail.com writes:
> The following bug has been logged on the website:
> Bug reference:      14366
> Logged by:          peng sun
> Email address:      bluevaley@gmail.com
> PostgreSQL version: 9.6.0
> Operating system:   win8.1
> Description:

> select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]', false);
> in 9.6, got:
> [2, null, 3]
> in 9.5.4, got:
> [[2, 3, 4], 2, null, 3]

Yeah, this is broken.  Fixed, thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: sunpeng
Date:
Subject: Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Next
From: Michael Paquier
Date:
Subject: Re: BUG #14366: jsonb_set() error when modify array element