Using IN clause

[kleschenko]

Is there any way to pass tuple/list as argument for IN clause? Seems like the only way to do it right now is to manually construct a query string like this WHERE "my_field" IN ($1, $2, $3). Am I missing something?

[elprans]

WHERE my_field = any($1::int[]) should work.

[kleschenko]

oh, forgot about ANY. It works this way, thanks!

[1st1]

Closing this now.