Kurt,
> Of course, I could modify the application and send different SQL
> depending on which case we're in or just constructing a query with a
> literal each time, but is there a way to add a hint to the SQL that
> would cause the query to be re-planned if it's a case that could use the
> index? Or can I convince the (Perl) driver to do so?
There should be an option to tell DBD::Pg not to cache a query plan.
Let's see ....
yes. pg_server_prepare=0, passed to the prepare() call.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco