into_values()

Since 1.16.0

Return the N lowest values seen by the aggregate.

Samples

Find the bottom 5 values from i * 13 % 10007 for i = 1 to 10000.

SELECT toolkit_experimental.into_values(
    toolkit_experimental.min_n(sub.val, 5))
FROM (
  SELECT (i * 13) % 10007 AS val
  FROM generate_series(1,10000) as i
) sub;

Output:

into_values
---------------------------------
1
2
3
4
5

Arguments

The syntax is:

into_values (
    agg MinN
) SETOF BIGINT | SETOF DOUBLE PRECISION | SETOF TIMESTAMPTZ

Name	Type	Default	Required	Description
agg	MinN	-	✔	The aggregate to return the results from. Note that the exact type here varies based on the type of data stored.

Returns

Column	Type	Description
into_values	SETOF BIGINT | SETOF DOUBLE PRECISION | SETOF TIMESTAMPTZ	The lowest values seen while creating this aggregate.