diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 16 | ||||
| -rw-r--r-- | doc/src/sgml/json.sgml | 5 |
2 files changed, 13 insertions, 8 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index f8d9e460937..37e37672d42 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10333,32 +10333,36 @@ table2-mapping <row> <entry><literal>@></literal></entry> <entry><type>jsonb</type></entry> - <entry>Does the left JSON value contain within it the right value?</entry> + <entry>Does the left JSON value contain the right JSON + path/value entries at the top level?</entry> <entry><literal>'{"a":1, "b":2}'::jsonb @> '{"b":2}'::jsonb</literal></entry> </row> <row> <entry><literal><@</literal></entry> <entry><type>jsonb</type></entry> - <entry>Is the left JSON value contained within the right value?</entry> + <entry>Are the left JSON path/value entries contained at the top level within + the right JSON value?</entry> <entry><literal>'{"b":2}'::jsonb <@ '{"a":1, "b":2}'::jsonb</literal></entry> </row> <row> <entry><literal>?</literal></entry> <entry><type>text</type></entry> - <entry>Does the key/element <emphasis>string</emphasis> exist within - the JSON value?</entry> + <entry>Does the <emphasis>string</emphasis> exist as a top-level + key within the JSON value?</entry> <entry><literal>'{"a":1, "b":2}'::jsonb ? 'b'</literal></entry> </row> <row> <entry><literal>?|</literal></entry> <entry><type>text[]</type></entry> - <entry>Do any of these key/element <emphasis>strings</emphasis> exist?</entry> + <entry>Do any of these array <emphasis>strings</emphasis> + exist as top-level keys?</entry> <entry><literal>'{"a":1, "b":2, "c":3}'::jsonb ?| array['b', 'c']</literal></entry> </row> <row> <entry><literal>?&</literal></entry> <entry><type>text[]</type></entry> - <entry>Do all of these key/element <emphasis>strings</emphasis> exist?</entry> + <entry>Do all of these array <emphasis>strings</emphasis> exist + as top-level keys?</entry> <entry><literal>'["a", "b"]'::jsonb ?& array['a', 'b']</literal></entry> </row> <row> diff --git a/doc/src/sgml/json.sgml b/doc/src/sgml/json.sgml index 1e78558e27a..b4b390b23eb 100644 --- a/doc/src/sgml/json.sgml +++ b/doc/src/sgml/json.sgml @@ -369,8 +369,9 @@ SELECT '"foo"'::jsonb ? 'foo'; </para> <para> The default GIN operator class for <type>jsonb</> supports queries with - the <literal>@></>, <literal>?</>, <literal>?&</> - and <literal>?|</> operators. + top-level key-exists operators <literal>?</>, <literal>?&</> + and <literal>?|</> operators and path/value-exists operator + <literal>@></>. (For details of the semantics that these operators implement, see <xref linkend="functions-jsonb-op-table">.) An example of creating an index with this operator class is: |