"Jan Bilek" <bilekj(at)gmail(dot)com> writes:
> I would like to use this query in java PreparedStatement, where age of a =
> row would be one of its parameters:
> PreparedStatement could look like this:
> select * from mytable where creation_time > (CURRENT_TIMESTAMP - ?)
> But nothing works with PreparedStatements!
> I tried to set whole interval strings "interval '7 days'" as a parameter
> I tried to set time strings '7 days' as a parameter
> I tried to use BigDecimal as a parameter...
I'm not sure that Java has a type corresponding to "interval". Instead
use number-times-interval multiplication:
... creation_time > (CURRENT_TIMESTAMP - ? * interval '1 day')
The parameter is now of plain integer or float type.
regards, tom lane