Re: Array comparison - subset - Mailing list pgsql-general

From Tom Lane
Subject Re: Array comparison - subset
Date
Msg-id 9051.1157259548@sss.pgh.pa.us
Whole thread Raw
In response to Re: Array comparison - subset  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Array comparison - subset  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Michael Fuhr <mike@fuhr.org> writes:
> test=> SELECT ARRAY[1, 2, 3, 4] @ ARRAY[1, 3];
>  ?column?
> ----------
>  t
> (1 row)

> In 8.2 the above example will work in the stock installation for
> arrays of any type (i.e., with operands of type anyarray).

[ blink... ]  When did that get in, and why don't I see it in the
documentation?  The operand order seems exactly backward considering
that all the pre-existing @ operators are "contained in", not
"contains".  Should we flip this around before it's too late?

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Array comparison - subset
Next
From: Tom Lane
Date:
Subject: Re: Severe problems with PostgreSQL 7.4.7 installation, please help!