Re: Count dates distinct within an interval

Поиск
Список
Период
Сортировка
От Dmitry Tkach
Тема Re: Count dates distinct within an interval
Дата
Msg-id 3F141703.4080904@openratings.com
обсуждение исходный текст
Ответ на Re: Count dates distinct within an interval  (greg@turnstep.com)
Список pgsql-sql
>
>
>You need to elaborate on your logic some more, and state exactly what you 
>would want in the A,B,C case above. Does B get lumped with A or with C? 
>It is within 24 hours of both, after all. Does C not get lumped in with 
>B simply because B has already been lumped in with A?
>
Yes. The first (earliest) entry is counted, then all the later ones a 
skipped as long as they are within 24 hours from the last one, that's 
counted.
In this case, A is counted, B is skipped, because it is within 24 hours 
of A, then C is counted, because it is more than 24 hours from A.

Thanks!

Dima




В списке pgsql-sql по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: summing tables
Следующее
От: Jean-Luc Lachance
Дата:
Сообщение: Re: summing tables