From: | Andreas Gaab <A(dot)Gaab(at)scanlab(dot)de> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Running mean filtering using Window Functions? |
Date: | 2012-04-26 09:22:44 |
Message-ID: | 48DA836F3865C54B8FBF424A3B775AF6674B452B86@Exchange-Server |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
can I realize a running mean filter using window functions?
What I can think of is:
SELECT avg(random) OVER (PARTITION BY floor(time_s / 60) ORDER BY floor(time_s / 60))
FROM (
SELECT generate_series(0,600,20) time_s, random()
) as data;
which averages all measurements in one minute, but not every line with its following two lines.
Any suggestions?
Best regards
Andreas
___________________________________________________________________________
SCANLAB AG
Dr. Andreas Simon Gaab
Entwicklung * R & D
Siemensstr. 2a * 82178 Puchheim * Germany
Tel. +49 (89) 800 746-513 * Fax +49 (89) 800 746-199
mailto:a(dot)gaab(at)scanlab(dot)de * www.scanlab.de<http://www.scanlab.de>
Amtsgericht München: HRB 124707 * USt-IdNr.: DE 129 456 351
Vorstand: Georg Hofner (Sprecher), Christian Huttenloher, Norbert Petschik
Aufsichtsrat (Vorsitz): Dr. Hans J. Langer
___________________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Mitesh Shah | 2012-05-02 19:55:58 | pg_dump: aborting because of server version mismatch |
Previous Message | Greg Sabino Mullane | 2012-04-25 17:26:17 | Re: How can this INSERT fail? |