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.
Samples
Section titled “Samples”Calculate the sum of the integers from 0 to 100:
SELECT sum(stats_agg(data)) FROM generate_series(0, 100) data;sum-----5050Arguments
Section titled “Arguments”The syntax is:
sum( summary StatsSummary1D) RETURNS DOUBLE PRECISION| Name | Type | Default | Required | Description |
|---|---|---|---|---|
| summary | StatsSummary1D | - | ✔ | The statistical aggregate produced by a stats_agg call |
Returns
Section titled “Returns”| Column | Type | Description |
|---|---|---|
| sum | DOUBLE PRECISION | The sum of the values in the statistical aggregate |