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]);
and this doesn't:
select * from table_of_integers where integer_column in (array[5,6]);
Although documentation says:
9.20.4. ANY/SOME
[...]
SOME is a synonym for ANY. IN is equivalent to = ANY.
[...]
I thought that if IN is equivalent to = any, both queries above should work.
Am I missing something?
Thanks in advance.
--
Regards,
Francisco Figueiredo Jr.
Npgsql Lead Developer
http://www.npgsql.org
http://fxjr.blogspot.com
http://twitter.com/franciscojunior