Re: Sum of events over an interval; how?

It might help to have the structure of the table you're querying, like the
CREATE TABLE statement. Also what version of Postgres are you using?

Wes



S Dawalt <shane.dawalt@wright.edu>@postgresql.org on 02/18/2002 02:32:08 PM

Sent by:  pgsql-general-owner@postgresql.org


To:   pgsql-general@postgresql.org
cc:
Subject:  [GENERAL] Sum of events over an interval; how?



? 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