Re: jsonb_set array append hack? - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: jsonb_set array append hack?
Date
Msg-id CAM3SWZTtS25iQU3Djacfwxz=KHoX2tW8sbJmFwc1jTovLzqbLw@mail.gmail.com
Whole thread Raw
In response to Re: jsonb_set array append hack?  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: jsonb_set array append hack?  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
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.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Idea for improving buildfarm robustness
Next
From: Andrew Dunstan
Date:
Subject: Re: jsonb_set array append hack?