two dates

Поиск
Список
Период
Сортировка
От mixo
Тема two dates
Дата
Msg-id 3E5B1349.80705@beth.uniforum.org.za
обсуждение исходный текст
Ответы Re: two dates  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: "Natasa Bulatovic"
Дата:
Сообщение: Any limitation in size for return result from SELECT?
Следующее
От: "Tambet Matiisen"
Дата:
Сообщение: Re: good style?