I can then use built-in aggregate functions on the array to get the size and sum of those days overdue and compute an average.
然后我可以使用内置的聚合函数来获取过期天数的大小和总和并计算平均值。
Because the UPDATE is in the FROM clause it is easy to use the standard SUM to aggregate the end result.
因为UPDATE在from子句中,所以很容易使用标准SUM来聚集最终结果。
The statistical view currently does not support aggregate functions like SUM, MAX, distinct operations or set operation like UNION, EXCEPT or INTERSECT.
当前,统计视图不支持SUM、max之类的聚合函数,也不支持distinct操作和UNION、EXCEPT或INTERSECT之类的集合操作。
应用推荐