... you can't use placeholders for variable-length WHERE IN('foo', 'bar', 'baz') constructs.

PostgreSQL offers the following construct:

 where array[ column_name ] <@ ( ? )

you can then $sth->execute(), passing an arrayref (i.e.: ['foo', 'bar', 'baz'] ) to the single placeholder.


In reply to Re: What are placeholders in DBI, and why would I want to use them? by erix
in thread What are placeholders in DBI, and why would I want to use them? by btrott

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":