[GENERAL] Calculating a moving average

[Vanole, Mike]

Title: Message

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