Re: jsonb_set array append hack?

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: jsonb_set array append hack?
Дата
Msg-id 56104784.8010006@dunslane.net
обсуждение исходный текст
Ответ на Re: jsonb_set array append hack?  (Peter Geoghegan <pg@heroku.com>)
Список pgsql-hackers

On 10/03/2015 04:49 PM, Peter Geoghegan wrote:
> On Mon, Sep 21, 2015 at 2:21 PM, Andrew Dunstan <andrew@dunslane.net> wrote:
>>> Thanks for the explanation. So, basically, it should be like this, am I
>>> right?
>>>
>>> postgres=# SELECT jsonb_set(
>>>      '{"name": "Joe", "vehicle_types": ["car", "van"]}'::jsonb,
>>>      '{vehicle_types, nonsense}',
>>>      '"motorcycle"', true);
>>> ERROR:  path element at the position 2 is not an integer
>> That seems reasonable. For that matter, we should probably disallow NULL
>> path elements also, shouldn't we?
> Are you planning on getting this in by Monday, Andrew? It would be
> nice to have this fixed going into beta.
>


Yeah, will look at it tonight or tomorrow.

cheers

andrew



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: jsonb_set array append hack?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: creating extension including dependencies