How to find events within a timespan to each other?

Поиск
Список
Период
Сортировка
От Andreas
Тема How to find events within a timespan to each other?
Дата
Msg-id 4C34EF8F.5010202@gmx.net
обсуждение исходный текст
Список pgsql-sql
  Hi,

is there a way to find events in a log that happen within a certain 
timespan to each other?

Log is like this
event_id        integer   not null   default 0      primary key
event_type_id        integer   not null   default
user_id        integer   not null   default 0
event_ts      timestamp(0)

I need every event of a type that happened more often than one time 
within 5 minutes of another one of the same user.

17    3     1         ... 12:00
18    2     ....
19    3     1         ... 13:03
20    3     2         ... 13:03
21    3     1         ... 13:04
22    2    .....
23    3     1         ... 13:05
24    2     1         ... 13:06

E.g. the checked event_typ_id may be 3 then the result should be line 
19, 21, 23



regards
Andreas  :)


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

Предыдущее
От: Justin Graf
Дата:
Сообщение: Re: strangest thing happened
Следующее
От: Tim Landscheidt
Дата:
Сообщение: Re: How to find events within a timespan to each other?