9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
in 9.6,
select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
got:
[2, null, 3]
but in 9.6.5, got:
[[2, 3, 4], 2, null, 3]
peng
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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Wed, Oct 12, 2016 at 4: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.
Just saw your other email, I'll reply there directly. Please just
ignore this one.
--
Michael
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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:
Show quoted text
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