Calculating a moving average

From: "Vanole, Mike" <Mike(dot)Vanole(at)cingular(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Calculating a moving average
Date: 2005-01-19 21:34:25
Message-ID: EC80B396EC02F24C802F8C33FA8437E9A74679@TX-MSG10-ALN.wireless.attws.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I need to calculate a moving average and I would like to do it with SQL,
or a Pg function built for this purpose. I'm on Pg 7.4. Is this possible
in Pg without a bunch of self joins, or is there a funtion available?

Thanks,
Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ragnar Hafstað 2005-01-19 21:36:55 Re: Strange results of ORDER BY clause when item begins
Previous Message Dann Corbit 2005-01-19 21:30:32 Re: need an advice on running Database