Properties

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:  

SQL


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