num_vals()

Calculate the number of values in a one-dimensional statistical aggregate

Since 1.3.0

Calculate the number of values contained in a statistical aggregate.

Samples

Calculate the number of values from 0 to 100, inclusive:

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

num_vals
--------
101

Arguments

The syntax is:

num_vals(
  summary StatsSummary1D
) RETURNS BIGINT

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

Returns

Column	Type	Description
num_vals	BIGINT	The number of values in the statistical aggregate