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

Поиск
Список
Период
Сортировка
От sunpeng
Тема Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',
Дата
Msg-id CAOYKhLrLNU7-vvMNgyJSSJiGhvojgHGyR+MgXAUdptEYAUO8-Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',  (Michael Paquier <michael.paquier@gmail.com>)
Список 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:

> 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
>

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #14344: string_agg(DISTINCT ..) crash
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #14366: jsonb_set() error when modify array element