Re: Difference between "in (...)" and "= any(...)" queries when using arrays

Francisco Figueiredo Jr. wrote:
> Hi all!
>
> I was playing with "in (...)"  and "= any (...)" queries and found a
> difference between them and I wonder:
>
> why this works:
>
> select * from table_of_integers where integer_column = any (array[5,6]);

This checks if integer_column matches any value in the specified array.

> select * from table_of_integers where integer_column in (array[5,6]);

This checks if integer_column IS an array[5,6] (which it isn't).

You probably want ... IN (5,6)

> SOME is a synonym for ANY. IN is equivalent to = ANY.

I think this is probably talking with respect to sub-queries.

--
   Richard Huxton
   Archonet Ltd