The following bug has been logged online: Bug reference: 4110 Logged by: Josep Llort Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 8.2 8.3 Operating system: Ubuntu Linux Description: Error on select doing (date +1) Details:
I found it when I upgrading jdbc jar file. I was using postgresql-8.0-322.jdbc3.jar that runs propertly. I've tested all upper versions 8.1, 8.2, since postgresql-8.3-603.jdbc3.jar an all seems has the same problem. On my select i've got something like this: " and ? + cast(emp_estmin as int) <= ? + 1 " '?' are date initialized on java code with ps.setDate(4, new java.sql.Date(startDate.getTime())); The error occurs when trying to add some int value to a date ( to incremental purposes ). The error ocurred is: ERROR: invalid input syntax for integer: "2008-05-01 +02:00" -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
