Name: | avg1(interval) |
Input type: | interval |
Owner: | postgres |
State type: | interval[] |
State function: | interval_avg |
Final type: | interval |
Final function: | interval_avg |
Sort Operator: | |
Initial condition: | {0 second,0 second} |
System aggregate?: | |
Comment: |
CREATE AGGREGATE avg1 (
BASETYPE = interval,
SFUNC = interval_accum,
STYPE = interval[],
INITCOND = '{0 second,0 second}',
FINALFUNC = interval_avg
);
ALTER AGGREGATE public.avg1(interval) OWNER TO postgres;
See Also
List of aggregates