On Friday 05 September 2003 16:36, Rasmus Aveskogh wrote: > Richard, > > Thanks a lot! You were right - the query parser "misunderstood" > now() - '1 day'::interval and only used one of the indexes (as I already > noticed). > > Actually all I had to do was to cast the result like this: > > (now() - '1 day'::interval)::date > > 75s is not between 10ms and 200ms. > > Thanks again!
Ah - good. You also want to be careful with differences between timestamp with/without time zone etc. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster