<row>

<entry> <literal>@&gt;</literal> </entry>

<entry>contains</entry>

<entry><literal>ARRAY[1,4,3] @&gt; ARRAY[3,1]</literal></entry>

<entry><literal>ARRAY[1,4,3] @&gt; ARRAY[3,1,3]</literal></entry>

<entry><literal>t</literal></entry>

</row>

<row>

<entry> <literal>&lt;@</literal> </entry>

<entry>is contained by</entry>

<entry><literal>ARRAY[2,7] &lt;@ ARRAY[1,7,4,2,6]</literal></entry>

<entry><literal>ARRAY[2,2,7] &lt;@ ARRAY[1,7,4,2,6]</literal></entry>

<entry><literal>t</literal></entry>

</row>

</table>

<para>

Array comparisons compare the array contents element-by-element,

using the default B-tree comparison function for the element data type.

The array ordering operators (<literal>&lt;</literal>,

<literal>&gt;=</literal>, etc) compare the array contents

element-by-element, using the default B-tree comparison function for

the element data type, and sort based on the first difference.

In multidimensional arrays the elements are visited in row-major order

(last subscript varies most rapidly).

If the contents of two arrays are equal but the dimensionality is

number of dimensions or subscript ranges were different.)

</para>

<para>

The array containment operators (<literal>&lt;@</literal>

and <literal>@&gt;</literal>) consider one array to be contained in

another one if each of its elements appears in the other one.

Duplicates are not treated specially, thus <literal>ARRAY[1]</literal>

and <literal>ARRAY[1,1]</literal> are each considered to contain the

other.

</para>

<para>

See <xref linkend="arrays"> for more details about array operator

behavior. See <xref linkend="indexes-types"> for more details about