From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Implement array version of jsonb_delete and operator |
Date: | 2017-01-18 20:42:09 |
Message-ID: | E1cTx3Z-0006kf-KL@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Implement array version of jsonb_delete and operator
This makes it possible to delete multiple keys from a jsonb value by
passing in an array of text values, which makes the operaiton much
faster than individually deleting the keys (which would require copying
the jsonb structure over and over again.
Reviewed by Dmitry Dolgov and Michael Paquier
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/d00ca333c338b40911e89939c3cc771025978595
Modified Files
--------------
doc/src/sgml/func.sgml | 8 ++++
src/backend/utils/adt/jsonfuncs.c | 86 +++++++++++++++++++++++++++++++++++++
src/include/catalog/pg_operator.h | 2 +
src/include/catalog/pg_proc.h | 3 +-
src/test/regress/expected/jsonb.out | 18 ++++++++
src/test/regress/sql/jsonb.sql | 4 ++
6 files changed, 120 insertions(+), 1 deletion(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2017-01-18 21:09:17 | pgsql: Change some test macros to return true booleans |
Previous Message | Tom Lane | 2017-01-18 20:22:18 | pgsql: Disable transforms that replaced AT TIME ZONE with RelabelType. |