Re: @> (contains)
Tom Lane <[email protected]> Mon, 23 Sep 2019 12:56:36 -0400
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
"David G. Johnston" <[email protected]> writes: > On Sun, Aug 18, 2019 at 8:53 AM PG Doc comments form <[email protected]> >> Noticed strange thin with @> >> Query "select '{1,2}'::int[] @> '{1,2,2,2,2,2,2,2}'::int[]" returns true, >> but first array contains even less elements then second. >> I think it's a bug in "contains" logic, but don't know where to submit it. > Its a valid interpretation of "contains", for this purpose each array is > treated like a set (ignoring the cardinality of elements, and overall > dimensionality), but it needs to be documented as behaving that way on that > page. Done now. regards, tom lane