two dates - Mailing list pgsql-sql

From mixo
Subject two dates
Date
Msg-id 3E5B1349.80705@beth.uniforum.org.za
Whole thread Raw
Responses Re: two dates
List pgsql-sql
I have a table which has serveral time stamps include when an entry was 
'created'.
Each entry is identified by a unique 'id'. How can I best find entries 
created
between two dates without going through each day between the two dates?

Currently, going through each day to get the results takes about 23 
minutes for 7 days
as I have two other criteria for search: roughly I am doing about 
16*17*n queries,
where n=days between two dates (for 7 days, 16*17*7 = which a number 
that is
too big for my liking).




pgsql-sql by date:

Previous
From: "Natasa Bulatovic"
Date:
Subject: Any limitation in size for return result from SELECT?
Next
From: "Tambet Matiisen"
Date:
Subject: Re: good style?