Project

General

Profile

Bug #4936

Modify averaging functions

Added by Aurynn Shaw over 15 years ago. Updated over 15 years ago.

Status:
New
Priority:
High
Assignee:
Aurynn Shaw
Start date:
Due date:
% Done:

0%

Estimated time:
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

No data to display

Also available in: Atom PDF