Re: [GENERAL] Fwd: Query parameter types not recognized
| От | Arjen Nienhuis |
|---|---|
| Тема | Re: [GENERAL] Fwd: Query parameter types not recognized |
| Дата | |
| Msg-id | CAG6W84JRY7y=Go5FrM4WzwFrYVDKXvM5jPa6CBHpcnTSegAEuA@mail.gmail.com обсуждение исходный текст |
| Ответ на | [GENERAL] Fwd: Query parameter types not recognized (Roberto Balarezo <rober710@gmail.com>) |
| Ответы |
Re: [GENERAL] Fwd: Query parameter types not recognized
Re: [GENERAL] Fwd: Query parameter types not recognized |
| Список | pgsql-general |
On Feb 10, 2017 8:11 PM, "Roberto Balarezo" <rober710@gmail.com> wrote:
Hi, I would like to know why this is happening and some advice if there is a way to solve this problem:I have a query like this:
select COALESCE(duedate, ? + 1) from invoices order by duedate desc limit 10;where ? is a query parameter. I’m using JDBC to connect to the database, and sending parameters like this:
query.setDate(1, defaultDueDate);
If you want to add to a date you cannot just add 1. You need an interval: coalesce(duedate, ? + interval '1 day')
See:
В списке pgsql-general по дате отправления: