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