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

Yes Craig's way is better. I was only thinking of handling the string
interpolation itself rather than generating the interval itself.

I'd probably use the ::interval cast syntax though, so something like:
checkin_time > (CURRENT_DATE - (? * '1 day'::interval))

Regards,
-- Sehrope Sarkuni
Founder & CEO | JackDB, Inc. | http://www.jackdb.com/

On Tue, Aug 12, 2014 at 12:02 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
> 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