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 :)
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
