On Wed, Oct 17, 2007 at 07:37:15AM -0700, Jason L. Buberel wrote: > 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 ); You're asking here whether "date" matches a single item named by parameter "4". > Any quick syntax fix for this? Try: date = ANY ($4); "ANY" treats its parameter as an array, so will accept an array as a parameter. I've not tried this on a large dataset, so I'm not sure what sort of performance characteristics you should expect. Sam ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
