Got it!
"Jan Bilek" <[EMAIL PROTECTED]> 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')
Integer-interval multiplication is the way!!!
Many thanks for quick help.
(Java seems not to have oracle/postgre interval type)
The parameter is now of plain integer or float type.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
