From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Carsten Friedrich" <carsten(at)dtecht(dot)com(dot)au> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: JDBC 7.4 to 8.1 regression problem |
Date: | 2006-07-14 16:15:01 |
Message-ID: | 21246.1152893701@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
"Carsten Friedrich" <carsten(at)dtecht(dot)com(dot)au> writes:
> I use the following prepared statement:
> final static String SQL= "SELECT " +
> [...]
> " WHERE " +
> [...]
> + " AND service_date <= ?" +
> " and service_date > date ? - interval '365 days'; "
The above is broken code, and always has been: the fact that it failed
to malfunction back in 7.4 was purely accidental. You can only use the
syntax "typename literal" with a literal constant. Instead of "date ?"
use "?::date", or if you want to be fully SQL-spec-compliant write it
out as "CAST(? AS date)".
Actually, it'd probably be better to use "date_trunc('day', ?)" anyway,
since that's what you're trying to achieve with the cast.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jennie Browne | 2006-07-18 13:11:09 | PreparedStatment Memory Size |
Previous Message | Carsten Friedrich | 2006-07-14 02:01:28 | JDBC 7.4 to 8.1 regression problem |