sum()

Calculate the sum from a one-dimensional statistical aggregate

Since 1.3.0

Calculate the sum of the values contained in a statistical aggregate.

sum(
  summary StatsSummary1D
) RETURNS DOUBLE PRECISION

Arguments

Name	Type	Default	Required	Description
summary	StatsSummary1D	-	✔	The statistical aggregate produced by a stats_agg call

Returns

Column	Type	Description
sum	DOUBLE PRECISION	The sum of the values in the statistical aggregate

Samples

Calculate the sum of the integers from 0 to 100:

SELECT sum(stats_agg(data))
  FROM generate_series(0, 100) data;

sum
-----
5050