Modify averaging functions
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