Re: Error with a SQL query 'between .. and .. and'

Turbo Fredriksson <turbo(at)bayour(dot)com> writes:
> This SQL query works in 7.1.3, but not in 7.2, how come?
> select count(*) from log where starttime between now()-interval(60*60) and now() and statuscode='2';
> ERROR: parser: parse error at or near "*"

interval(n) is a type name now, as required by SQL92.

Try

"interval"(60*60)
(60*60)::interval
CAST (60*60 AS interval)

Only the last of these is actually standard.

regards, tom lane