On 09/21/2015 12:13 PM, Dmitry Dolgov wrote:
> I would expect some kind of error. We're trying to address a
position in an array, and we're instead passing a key. If it
completes successfully, the chances are it isn't what the user intended.
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?
cheers
andrew
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers