Re: Sequential event query - Mailing list pgsql-sql

From Steve Crawford
Subject Re: Sequential event query
Date
Msg-id 48627C8B.10200@pinpointresearch.com
Whole thread Raw
In response to Re: Sequential event query  (Steve Crawford <scrawford@pinpointresearch.com>)
List 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 by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Sequential event query
Next
From: Mark Stosberg
Date:
Subject: Re: GROUP BY on a column which might exist in one of two tables