Alex Turner <armtuk@gmail.com> writes:
> -> Seq Scan on weblog_entry (cost=0.00..940.85 rows=4452 width=40)
> Filter: ((request_time)::text > ((('now'::text)::time(6) with
> time zone - '00:01:00'::interval))::text)
> This explain plain seems to me to be saying that it's casting the
> timestamp to a text type before comparing with my
> current_time-interval.
Yup.
> Is this the right behaviour?
Hard to say. You did not say what the datatype of request_time is.
The whole thing looks a bit bogus though --- isn't it going to fail near
midnight due to wraparound? Seems like you should be using timestamps
not times of day.
regards, tom lane