How to find events within a timespan to each other? - Mailing list 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  :)