-- for postgres you can simplify that a bit by where field = any ( ? ) -- followed by $sth->execute(\@values) -- note the backslash