Re: IN and ANY

Tom Lane wrote:
> I don't have a strong opinion about "IN array", but am worried that
> allowing it would create ambiguity about which interpretation is meant.
> Is the left-hand side supposed to be compared against the whole array or
> each array member?

That was exactly the problem. IN (array) does work if the left-hand side
is also an array, and the right-hand side is taken as a value list:

regression=# select 1 where array[1] in (array[1]);
?column?
----------
1
(1 row)

regression=# select 1 where array[1] in (array[1,2]);
?column?
----------
(0 rows)

There was discussion on this back in the May-June 2003 timeframe --
please check the archives.

Joe