average()

average(
    tws TimeWeightSummary
) RETURNS DOUBLE PRECISION

A function to compute a time weighted average from a TimeWeightSummary.

Required arguments

Returns

Sample usage

SELECT
    id,
    average(tws)
FROM (
    SELECT
        id,
        time_weight('LOCF', ts, val) AS tws
    FROM foo
    GROUP BY id
) t