From: D'Arcy J.M. Cain <darcy@druid.net>
To: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
Cc: pgsql-sql@PostgreSQL.org
Subject: Re: problem with sql
Date: Sat, 1 Jun 2002 06:35:10 -0400
Message-ID: <20020601103511.651FC1B01@druid.net> (raw)
In-Reply-To: <F73dSdVudU5N3FwtFR30000b12b@hotmail.com>
References: <F73dSdVudU5N3FwtFR30000b12b@hotmail.com>
On May 31, 2002 08:32 pm, Ricardo Javier Aranibar León wrote:
> I think that my head will exploit, I can't resolve this problem and I hope
> that somebody can help me.
Can't have that. It might leave a mess in our nice, clean mailing list. :-)
> My data base stores the statistics of ping that are generated every minute.
> For a day I have 1440 registers, I want to group them every 5 minutes.
> I use this:
> hb#select sum(tras), sum(lost), avg(min), avg(prom), avg(max) from simon
> where fecha='2002-05-31' and ip='166.114.214.22' and hora between '00:00'
> and '00:05';
>
> This work for five register, but i like that this function as a bucle every
> 5 minutes for example in the next report the interval of hora between
> '00:05' and '00:10' the next hora between '00:10' and '00:15'.....until
> arrive hora between '23:55' and '24:00'
Well, how accurate does this have to be? Are you just trying to see some
statisticle correlations or do you need to actually count each bing once and
only once for some sort of accounting purposes. I assume the former in which
case the following may be what you are looking for..
...where hora between 'NOW'::timestamp - '5 MINUTE'::interval and 'NOW.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: darcy@druid.net, ricardo_jal@hotmail.com
Subject: Re: problem with sql
In-Reply-To: <20020601103511.651FC1B01@druid.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox