projectwonder/wonder — pull request #161 by johnthuss (2012-04-24 15:27:29+00:00)
Title: Postgres IN(...) clause bind variables

In the past for Postgres bind variables were fairly problematic in general (all situations)
in older versions of Postgres because the types of values was not determined well and that
often prevented it from properly utilizing indices when it should have. This problem was
eventually lessened by adding explicit type-casts to the binding values and then by
Postgres itself fixing the problem directly in the database. So this is what was meant by
the comment "The Postgres Expression has a problem using bind variables" in
PostgresqlSQLHelper.formatValueForAttribute. This problem is no longer present in
Postgres, so it's totally safe to change this so that bind variables will be used
(if configured) by removing the override of formatValueForAttribute.

Links to relevant changes in SVN history:

http://wonder.svn.sourceforge.net/viewvc/wonder/trunk/Wonder/Common/Frameworks/ERExtensions/Sources/er/extensions/ERXEOAccessUtilities.java?r1=2875&r2=2913&pathrev=7103

http://wonder.svn.sourceforge.net/viewvc/wonder/trunk/Wonder/Common/Frameworks/ERExtensions/Sources/er/extensions/ERXEOAccessUtilities.java?r1=3191&r2=3219&pathrev=7103

http://wonder.svn.sourceforge.net/viewvc/wonder/trunk/Wonder/Frameworks/Core/ERExtensions/Sources/er/extensions/jdbc/ERXSQLHelper.java?revision=7710&view=markup

http://wonder.svn.sourceforge.net/viewvc/wonder/trunk/Wonder/PlugIns/PostgresqlPlugIn/Sources/com/webobjects/jdbcadaptor/PostgresqlExpression.java?view=log&pathrev=7700