Tobias Brox wrote:

[EMAIL PROTECTED] - Tue at 08:33:58PM +0200]

I use FreeBSD 4.11 with PostGreSQL 7.3.8.


database=> explain select date_trunc('hour', time),count(*) as total from
test where p1=53 and time > now() - interval '24 hours' group by
date_trunc order by date_trunc ;

I haven't looked through all your email yet, but this phenomena have been up
at the list a couple of times.  Try replacing "now() - interval '24 hours'"
with a fixed time stamp, and see if it helps.

pg7 will plan the query without knowledge of what "now() - interval '24
hours'" will compute to.  This should be fixed in pg8.

The grandparent was a mailing list double send. Notice the date is 1
week ago. It has already been answered (though your answer is still


Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to