diff options
Diffstat (limited to 'doc/src/sgml/func.sgml')
-rw-r--r-- | doc/src/sgml/func.sgml | 16 |
1 files changed, 10 insertions, 6 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 262f5eea9fb..11bd6ea0f1b 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -10331,32 +10331,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> |