@@ -14004,14 +14004,14 @@ SELECT NULLIF(value, '(none)') ...
14004
14004
<row>
14005
14005
<entry> <literal>@></literal> </entry>
14006
14006
<entry>contains</entry>
14007
- <entry><literal>ARRAY[1,4,3] @> ARRAY[3,1]</literal></entry>
14007
+ <entry><literal>ARRAY[1,4,3] @> ARRAY[3,1,3 ]</literal></entry>
14008
14008
<entry><literal>t</literal></entry>
14009
14009
</row>
14010
14010
14011
14011
<row>
14012
14012
<entry> <literal><@</literal> </entry>
14013
14013
<entry>is contained by</entry>
14014
- <entry><literal>ARRAY[2,7] <@ ARRAY[1,7,4,2,6]</literal></entry>
14014
+ <entry><literal>ARRAY[2,2, 7] <@ ARRAY[1,7,4,2,6]</literal></entry>
14015
14015
<entry><literal>t</literal></entry>
14016
14016
</row>
14017
14017
@@ -14054,8 +14054,10 @@ SELECT NULLIF(value, '(none)') ...
14054
14054
</table>
14055
14055
14056
14056
<para>
14057
- Array comparisons compare the array contents element-by-element,
14058
- using the default B-tree comparison function for the element data type.
14057
+ The array ordering operators (<literal><</literal>,
14058
+ <literal>>=</literal>, etc) compare the array contents
14059
+ element-by-element, using the default B-tree comparison function for
14060
+ the element data type, and sort based on the first difference.
14059
14061
In multidimensional arrays the elements are visited in row-major order
14060
14062
(last subscript varies most rapidly).
14061
14063
If the contents of two arrays are equal but the dimensionality is
@@ -14066,6 +14068,15 @@ SELECT NULLIF(value, '(none)') ...
14066
14068
number of dimensions or subscript ranges were different.)
14067
14069
</para>
14068
14070
14071
+ <para>
14072
+ The array containment operators (<literal><@</literal>
14073
+ and <literal>@></literal>) consider one array to be contained in
14074
+ another one if each of its elements appears in the other one.
14075
+ Duplicates are not treated specially, thus <literal>ARRAY[1]</literal>
14076
+ and <literal>ARRAY[1,1]</literal> are each considered to contain the
14077
+ other.
14078
+ </para>
14079
+
14069
14080
<para>
14070
14081
See <xref linkend="arrays"/> for more details about array operator
14071
14082
behavior. See <xref linkend="indexes-types"/> for more details about
@@ -18223,7 +18234,7 @@ SELECT has_function_privilege('joeuser', 'myfunc(int, text)', 'execute');
18223
18234
<row>
18224
18235
<entry> <literal>@></literal> </entry>
18225
18236
<entry>contains element</entry>
18226
- <entry><literal>'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @> 'calvin=r*w/hobbes'::aclitem</literal></entry>
18237
+ <entry><literal>'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @> 'calvin=r*w/hobbes'::aclitem</literal></entry>
18227
18238
<entry><literal>t</literal></entry>
18228
18239
</row>
18229
18240