<row>

<entry><literal>@&gt;</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 &#64;&gt; '{"b":2}'::jsonb</literal></entry>

</row>

<row>

<entry><literal>&lt;@</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 &lt;@ '{"a":1, "b":2}'::jsonb</literal></entry>

</row>

<row>

<entry><literal>?</literal></entry>

<entry><type>text</type></entry>

<entry>Does thekey/element<emphasis>string</emphasis> existwithin

the JSON value?</entry>

<entry>Does the <emphasis>string</emphasis> existas a top-level

key withinthe 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>?&amp;</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 ?&amp; array['a', 'b']</literal></entry>

</row>

<row>

</para>

<para>

The default GIN operator class for <type>jsonb</> supports queries with

the <literal>@&gt;</>, <literal>?</>, <literal>?&amp;</>

and <literal>?|</> operators.

top-level key-exists operators <literal>?</>, <literal>?&amp;</>

and <literal>?|</> operators and path/value-exists operator

<literal>@&gt;</>.

(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:

DATA(insertOID=3246 ("@>"PGNSPPGUIDbff380238021632500jsonb_containscontselcontjoinsel ));

DESCR("contains");

DATA(insertOID=3247 ("?"PGNSPPGUIDbff3802251600jsonb_existscontselcontjoinsel ));

DESCR("exists");

DESCR("keyexists");

DATA(insertOID=3248 ("?|"PGNSPPGUIDbff380210091600jsonb_exists_anycontselcontjoinsel ));

DESCR("existsany");

DESCR("any key exists");

DATA(insertOID=3249 ("?&"PGNSPPGUIDbff380210091600jsonb_exists_allcontselcontjoinsel ));

DESCR("existsall");

DESCR("all keys exist");

DATA(insertOID=3250 ("<@"PGNSPPGUIDbff380238021632460jsonb_containedcontselcontjoinsel ));

DESCR("is contained by");

DATA(insertOID=3284 ("||"PGNSPPGUIDbff38023802380200jsonb_concat-- ));