Bug #4936

Modify averaging functions

Added by Aurynn Shaw 07/14/2008 (over 13 years) ago. Updated 07/14/2008 (over 13 years) ago.

Status:NewStart date:
Priority:HighDue date:
Assignee:Aurynn Shaw% Done:

0%

Category:-
Target version:-
Resolution:

Description

All plpgsql functions will need two new arguments, and one removed argument:

start DATE, end DATE, and removal of offset INT.

The functions will be altered in the following ways:

  • Determining the length of the WHILE loop from the date ranges, if present, instead of using the interval to calculate it.
  • Alter the queries to use the start DATE parameter to position the start of the set, and then utilize the WHILE loop to offset from that point, ie, WHERE date = date_start + (interval * iterations)::interval

Also available in: Atom PDF