Re: Sequential event query

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: Sequential event query
Дата
Msg-id 48627C8B.10200@pinpointresearch.com
обсуждение исходный текст
Ответ на Re: Sequential event query  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-sql
Steve Crawford wrote:
> Allan Kamau wrote:
>> Hi Steve,
>> Am having difficulties (there is a chance I could be the only one) 
>> trying to see how the results you've listed under "I would want to 
>> get:" section can be generated from the information you have provided 
>> in your implicit problem statement.
> Remember the events are listed chronologically. Stated verbosely:
>
> 1: Value 1 happened 1 sequential time
> 3: Value 3 happened 1 sequential time
> 1: Value 1 happened 1 sequential time
> 4:
> 4: Value 4 happened 2 sequential times ...
And for completeness I suppose I should state that I am aware that a run 
of, say, 4 sequential events includes runs of 1, 2 and 3 events. I'm 
only interested in the longest run in order to set thresholds.

Cheers,
Steve




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

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Sequential event query
Следующее
От: Mark Stosberg
Дата:
Сообщение: Re: GROUP BY on a column which might exist in one of two tables