Re: PreparedStatement error upon trying to set a '?' after interval keyword

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: PreparedStatement error upon trying to set a '?' after interval keyword
Дата
Msg-id 53E991F0.5000109@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: PreparedStatement error upon trying to set a '?' after interval keyword  (Sehrope Sarkuni <sehrope@jackdb.com>)
Ответы Re: PreparedStatement error upon trying to set a '?' after interval keyword
Список pgsql-jdbc
Дерево обсуждения 
On 08/12/2014 04:34 AM, Sehrope Sarkuni wrote:
>     AND checkin_time > (CURRENT_DATE - (? || ' days')::interval)


It's generally preferable to write

(? * INTERVAL '1' DAY)

instead.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-jdbc по дате отправления: