selecting using array as IN condition parameter - possible?

Hi, suppose I have a query such as

select * from blah where (a,b) in ( (1,2),(2,3),(3,4)...)

I'd like to do this using jdbc and use a list/array for the IN parameter.

using postgresql 8.3, it is possible to rewrite it so that I am passing in an array instead of a hardcoded list as so

select * from blah where (a, b)::myPairType = any ( array of myPairType)

provided I've created a type (myPairType) to represent my data pair and a comparison operator for the new data type.

My question is therefore is it possible to pass an array of this type using jdbc or alternatively pass an array of arrays to represent my pair and convert that in the sql?

Thanks

John
--

Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/