Re: IN and ANY

On Tue, 2 Mar 2004, Joe Conway wrote:

> 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)

The only reason I brought it up was that to me ANY and IN are pretty much
the same kind of operator. Up until now I thought that IN really was the
same as =ANY, but it isn't. I don't like that but of course I have to
accept it. I would rather have had some elem function/operator for arrays
like:
 1 ELEM IN array[1,2]

or
 1 = ANY ELEM arra[1,2]

But as usual I'm 6 months late with my objections :-)

-- 
/Dennis Björklund