@@ -14058,14 +14058,14 @@ SELECT NULLIF(value, '(none)') ...
14058
14058
<row>
14059
14059
<entry> <literal>@></literal> </entry>
14060
14060
<entry>contains</entry>
14061
- <entry><literal>ARRAY[1,4,3] @> ARRAY[3,1]</literal></entry>
14061
+ <entry><literal>ARRAY[1,4,3] @> ARRAY[3,1,3 ]</literal></entry>
14062
14062
<entry><literal>t</literal></entry>
14063
14063
</row>
14064
14064
14065
14065
<row>
14066
14066
<entry> <literal><@</literal> </entry>
14067
14067
<entry>is contained by</entry>
14068
- <entry><literal>ARRAY[2,7] <@ ARRAY[1,7,4,2,6]</literal></entry>
14068
+ <entry><literal>ARRAY[2,2, 7] <@ ARRAY[1,7,4,2,6]</literal></entry>
14069
14069
<entry><literal>t</literal></entry>
14070
14070
</row>
14071
14071
@@ -14108,8 +14108,10 @@ SELECT NULLIF(value, '(none)') ...
14108
14108
</table>
14109
14109
14110
14110
<para>
14111
- Array comparisons compare the array contents element-by-element,
14112
- using the default B-tree comparison function for the element data type.
14111
+ The array ordering operators (<literal><</literal>,
14112
+ <literal>>=</literal>, etc) compare the array contents
14113
+ element-by-element, using the default B-tree comparison function for
14114
+ the element data type, and sort based on the first difference.
14113
14115
In multidimensional arrays the elements are visited in row-major order
14114
14116
(last subscript varies most rapidly).
14115
14117
If the contents of two arrays are equal but the dimensionality is
@@ -14120,6 +14122,15 @@ SELECT NULLIF(value, '(none)') ...
14120
14122
number of dimensions or subscript ranges were different.)
14121
14123
</para>
14122
14124
14125
+ <para>
14126
+ The array containment operators (<literal><@</literal>
14127
+ and <literal>@></literal>) consider one array to be contained in
14128
+ another one if each of its elements appears in the other one.
14129
+ Duplicates are not treated specially, thus <literal>ARRAY[1]</literal>
14130
+ and <literal>ARRAY[1,1]</literal> are each considered to contain the
14131
+ other.
14132
+ </para>
14133
+
14123
14134
<para>
14124
14135
See <xref linkend="arrays"/> for more details about array operator
14125
14136
behavior. See <xref linkend="indexes-types"/> for more details about
@@ -18277,7 +18288,7 @@ SELECT has_function_privilege('joeuser', 'myfunc(int, text)', 'execute');
18277
18288
<row>
18278
18289
<entry> <literal>@></literal> </entry>
18279
18290
<entry>contains element</entry>
18280
- <entry><literal>'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @> 'calvin=r*w/hobbes'::aclitem</literal></entry>
18291
+ <entry><literal>'{calvin=r*w/hobbes,hobbes=r*w*/postgres}'::aclitem[] @> 'calvin=r*w/hobbes'::aclitem</literal></entry>
18281
18292
<entry><literal>t</literal></entry>
18282
18293
</row>
18283
18294