Doc: clarify handling of duplicate elements in array containment tests.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 216bcf583802011365b8bb038b4e73f143e857b2
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2019-09-23T16:37:04Z
Releases: 12.0
Doc: clarify handling of duplicate elements in array containment tests.

The array <@ and @> operators do not worry about duplicates: if every
member of array X matches some element of array Y, then X is contained
in Y, even if several members of X get matched to the same Y member.
This was not explicitly stated in the docs though, so improve matters.

Discussion: https://postgr.es/m/156614120484.1310.310161642239149585@wrigleys.postgresql.org

Files

PathChange+/−
doc/src/sgml/func.sgml modified +16 −5

Documentation touched

Discussion