Sum of events over an interval; how?

Поиск

Список

Период

Сортировка

От	S Dawalt
Тема	Sum of events over an interval; how?
Дата	18 февраля 2002 г. 14:44:52
Msg-id	007d01c1b8b2$f4326f40$23b16c82@HP0E2E6GKYFJS4 обсуждение исходный текст
Ответы	Re: Sum of events over an interval; how?
Список	pgsql-general

Дерево обсуждения

I have a number of records having a timestamp when something happened. I am trying to find the number of events (records) that happened per minute over an hour timespan. I just cannot figure out how to do this. Maybe it's not possible? Would a plpgsql function be a good idea so that the number of front-end/back-end requests is small? I'm looking for some output (or maybe temp table) of:

Time Count

2/17/2002 22:00:00 4

2/17/2002 22:01:00 7

2/17/2002 22:02:00 14

....

Any help, even "Can't be done" is appreciated.

Shane A. Dawalt
********************************************
Network Engineer
Wright State University
Dayton, OH 45435 USA
Phone: 937-775-4089
Email: shane.dawalt@wright.edu

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

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Sum of events over an interval; how?