From: | wsheldah(at)lexmark(dot)com |
---|---|
To: | S Dawalt <shane(dot)dawalt(at)wright(dot)edu> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Sum of events over an interval; how? |
Date: | 2002-02-18 20:34:58 |
Message-ID: | OF16D1F357.FBDBA6CA-ON85256B64.0070FF92@lexmark.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)dawalt(at)wright(dot)edu>@postgresql.org on 02/18/2002 02:32:08 PM
Sent by: pgsql-general-owner(at)postgresql(dot)org
To: pgsql-general(at)postgresql(dot)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(dot)dawalt(at)wright(dot)edu
From | Date | Subject | |
---|---|---|---|
Next Message | David Griffiths | 2002-02-18 20:43:37 | Re: Work Around for Oracle Context Indexes? |
Previous Message | wsheldah | 2002-02-18 20:32:58 | Re: MDB 2 POSTGRESQL MIGRATION PROBLEM |