Skip to main content
Since 1.0.0 Get the minimum value from a tdigest. This accessor allows you to calculate the minimum alongside percentiles, without needing to create two separate aggregates from the same raw data.
min_val(
  digest TDigest
) RETURNS DOUBLE PRECISION

Arguments

NameTypeDefaultRequiredDescription
digestTDigest-The digest to extract the minimum value from

Returns

ColumnTypeDescription
min_valDOUBLE PRECISIONThe minimum value entered into the tdigest

Samples

Get the minimum of the integers from 1 to 100.
SELECT min_val(tdigest(100, data))
  FROM generate_series(1, 100) data;
min_val
---------
      1