Prepared statement parameters for an 'IN ()' clause

["Jason L. Buberel" <jason@xxxxxxxxxxx>]

Can someone point me to an example of creating a prepared statement for a query with an 'IN' clause?

The query looks like this:

select value from table where
state = $1 and city = $2 and zip = $3 and
date in ( $4 );

For the prepared statement, I have tried:

prepare st1(text, text, text, text[] );

Then invoked it as:

execute st1('CA', 'SUNNYVALE', '94086', '{2007-10-01,2007-09-25,2007-09-15}' );

But the use of the text array as input parameter does not seem to be correctly used in the 'IN' clause. My query consistently returns no results.

Any quick syntax fix for this?

Thanks
Jason