Обсуждение: BUG #4110: Error on select doing (date +1)

Поиск
Список
Период
Сортировка

BUG #4110: Error on select doing (date +1)

От
"Josep Llort"
Дата:
The following bug has been logged online:

Bug reference:      4110
Logged by:          Josep Llort
Email address:      Jllort@git.es
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"