Postgres Pro
Downloads
Home   >   mailing lists

Re: PreparedStatement error upon trying to set a '?' after interval keyword - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: PreparedStatement error upon trying to set a '?' after interval keyword
Date
Msg-id 53E991F0.5000109@2ndquadrant.com
Whole thread Raw
In response to Re: PreparedStatement error upon trying to set a '?' after interval keyword  (Sehrope Sarkuni <sehrope@jackdb.com>)
Responses Re: PreparedStatement error upon trying to set a '?' after interval keyword  (Sehrope Sarkuni <sehrope@jackdb.com>)
List pgsql-jdbc
Tree view 
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 by date:

Previous
From: Sehrope Sarkuni
Date:
Subject: Re: PreparedStatement error upon trying to set a '?' after interval keyword
Next
From: Sehrope Sarkuni
Date:
Subject: Re: PreparedStatement error upon trying to set a '?' after interval keyword