On 10 Apr 2002 at 11:51, Gaetano Mendola wrote: > "Jean-Christophe ARNU (JX)" <[EMAIL PROTECTED]> wrote: > > Hello all. > > I've a performance problem on specific requests : > > > > When I use timestamps + interval in where clauses, query performance is > > slowed down by a factor of 20 or 30!!!! For exemple : > > select timestamp,value > > from measure > > where timestamp<now() and timestamp>(now() - '1 hour'::interval)
Try where timestamp<now() and timestamp>(now() - '1 hour'::interval)::timestemp. -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
