]> granicus.if.org Git - postgresql/commit
Desupport jsonb subscript deletion on objects
authorAndrew Dunstan <andrew@dunslane.net>
Mon, 8 Jun 2015 00:46:00 +0000 (20:46 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Mon, 8 Jun 2015 00:46:00 +0000 (20:46 -0400)
commitb81c7b4098f52e64df89efe1461ba00a54649a10
tree924db92137a235ef088724a3a967799f13da38a8
parentd23a3a603b8eed5e8e34b193d43e9ca5f380ef3f
Desupport jsonb subscript deletion on objects

Supporting deletion of JSON pairs within jsonb objects using an
array-style integer subscript allowed for surprising outcomes.  This was
mostly due to the implementation-defined ordering of pairs within
objects for jsonb.

It also seems desirable to make jsonb integer subscript deletion
consistent with the 9.4 era general purpose integer subscripting
operator for jsonb (although that operator returns NULL when an object
is encountered, while we prefer here to throw an error).

Peter Geoghegan, following discussion on -hackers.
doc/src/sgml/func.sgml
src/backend/utils/adt/jsonfuncs.c
src/test/regress/expected/jsonb.out
src/test/regress/expected/jsonb_1.out
src/test/regress/sql/jsonb.sql