Hello,
I have some function with integer[] argument and the body uses
"column = ANY( $1)" construction.
If I evaluate the function body in regular query I can see that index
on 'column' is not used.
When I change query into "column IN( x, y, z)" I can see that index
is used and of course the query time
is shorter. But in this case I have problem with appropriate argument
passing (array cannot be used with
IN)
My questions:
1. How to optimize ANY operator to use index on column (is it
possible?)
2. Or how to convert array into "integer list" acceptable by "IN
operator"
Has anyone some hint?
ml.
