Horton

Re: @> (contains)

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: php.pl.prices@gmail.com, pgsql-docs@lists.postgresql.org
Date: 2019-09-23T16:56:36Z
Lists: pgsql-docs 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sun, Aug 18, 2019 at 8:53 AM PG Doc comments form <noreply@postgresql.org>
>> 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

Commits

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