min_n()

Find the smallest values in a set of data

Since 1.16.0

Construct an aggregate that keeps track of the smallest values passed through it.

Arguments

Name	Type	Default	Required	Description
value	BIGINT | DOUBLE PRECISION | TIMESTAMPTZ	-	✔	The values passed into the aggregate
capacity	BIGINT	-	✔	The number of values to retain.

Returns

The compiled aggregate. Note that the exact type is MinInts, MinFloats, or MinTimes depending on the input type