min_n()

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

Arguments

The syntax is:

min_n(
    value BIGINT | DOUBLE PRECISION | TIMESTAMPTZ,
    capacity BIGINT
) MinN

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

Column	Type	Description
min_n	MinN	The compiled aggregate. Note that the exact type is `MinInts`, `MinFloats`, or `MinTimes` depending on the input type

⌘I