Tom Lane wrote:
> There are certainly cases where lack of parameter type information could
> lead to a poor plan, but they are corner cases.
I fear they are less of a corner case than you believe - they seem to
pop up regularly here on the JDBC list.
(This might be a reflection that applications using JDBC are often
web-facing apps with simple, index-heavy queries)
-O