diff options
| author | Magnus Hagander <magnus@hagander.net> | 2017-01-18 21:37:59 +0100 |
|---|---|---|
| committer | Magnus Hagander <magnus@hagander.net> | 2017-01-18 21:37:59 +0100 |
| commit | d00ca333c338b40911e89939c3cc771025978595 (patch) | |
| tree | 3ab70c9e6520291389cc8674afd11864c634fa9c /doc/src | |
| parent | c22ecc6562aac895f0f0529707d7bdb460fd2a49 (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index eb1b6984bf0..2504a466e6d 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10845,6 +10845,14 @@ table2-mapping </row> <row> <entry><literal>-</literal></entry> + <entry><type>text[]</type></entry> + <entry>Delete multiple key/value pairs or <emphasis>string</emphasis> + elements from left operand. Key/value pairs are matched based + on their key value.</entry> + <entry><literal>'{"a": "b", "c": "d"}'::jsonb - '{a,c}'::text[] </literal></entry> + </row> + <row> + <entry><literal>-</literal></entry> <entry><type>integer</type></entry> <entry>Delete the array element with specified index (Negative integers count from the end). Throws an error if top level |