From: Ricardo Javier Aranibar León <ricardo_jal@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: problem with sql
Date: Sat, 01 Jun 2002 00:32:00 +0000
Message-ID: <F73dSdVudU5N3FwtFR30000b12b@hotmail.com> (raw)
Hi list,
I think that my head will exploit, I can't resolve this problem and I hope
that somebody can help me.
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'
If somebody can help me I will thankfull
_________________________________________________________________
Descargue GRATUITAMENTE MSN Explorer en
http://explorer.yupimsn.com/intl.asp.
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: ricardo_jal@hotmail.com
Subject: Re: problem with sql
In-Reply-To: <F73dSdVudU5N3FwtFR30000b12b@hotmail.com>
* 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