The following bug has been logged online:
Bug reference: 2997
Logged by: Floyd Shackelford
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: windows xp
Description: parse error:
setObject("2004-August-15",java.sql.Types.DATE)
Details:
jdbc: postgresql-8.2-504.jdbc3.jar
this generates a number format exception:
preparedStatement.setObject(indx,"2004-August-15",java.sql.Types.DATE)
this works:
preparedStatement.setObject(indx,"2004-08-15",java.sql.Types.DATE)
i prefer to use the former.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
