Hi all,
Is it appropriate to use ANY() in a select statement as so?
SELECT * FROM table t WHERE t.id = ANY(ARRAY[1,2,3]);
A less trivial usage of the above would be to pass an array to a simple
function using it to return a range of arbitrary rows. The alternative to
this would be to (programmatically) call the function multiple times on a
list of arguments. Some questions:
1) How does ANY() behave on indexed columns?
2) How does ANY() behave when passed an array with one element?
3) Generally is it better to use ANY on a passed ARRAY, or to just call a
select multiple times (and aggregate the results)? Is ANY just a glorified
OR?
Shak
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
