pgsql: Desupport jsonb subscript deletion on objects

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Desupport jsonb subscript deletion on objects
Date: 2015-06-08 00:46:29
Message-ID: E1Z1lCv-00008l-2U@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b81c7b4098f52e64df89efe1461ba00a54649a10

Modified Files
--------------
doc/src/sgml/func.sgml | 5 +--
src/backend/utils/adt/jsonfuncs.c | 5 +++
src/test/regress/expected/jsonb.out | 56 ++-------------------------------
src/test/regress/expected/jsonb_1.out | 56 ++-------------------------------
src/test/regress/sql/jsonb.sql | 11 +------
5 files changed, 13 insertions(+), 120 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2015-06-08 01:33:28 pgsql: Clarify documentation of jsonb - text
Previous Message Peter Eisentraut 2015-06-08 00:42:13 pgsql: doc: Fix broken links in FOP build