From: Panos Kassianidis <pkas@inaccessnetworks.com>
To: pgsql-sql@postgresql.org
Subject: Filtering data based on timestamp
Date: Tue, 07 Feb 2006 17:40:35 +0200
Message-ID: <43E8BF73.9000802@inaccessnetworks.com> (raw)
Hello everybody,
I am building a data logging application and I am facing the following
problem. I have a table which holds timestamp-value pairs for a recorded
variable. I would like to be able to select a range of values between
a starting
and an ending timestamp but also specify an interval over which values
should be averaged. For example let's say I have 180 values recorded
over the last 3 hours
(1 per minute)
and I would like to retrieve values recorded in the last 2 hours but
with an interval of 5 minutes, which means that my query should return
one tuple for every 5 tuples in the table and the value of this tuple
should be an average of 5 values.
Does anyone have any clue how I can make this query? I have though
about somehow grouping the tuples with group by and use the AVG
function but the tuples don't have anything in common to be grouped by.
Thank you very much in advance.
Panos
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: pkas@inaccessnetworks.com
Subject: Re: Filtering data based on timestamp
In-Reply-To: <43E8BF73.9000802@inaccessnetworks.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