Alex Turner <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to