NUMBERS

Description

Table function that generates a temporary table containing only one column with the column name number and all element values are const_value if const_value is specified, otherwise they are [0,number) incremented.

Syntax

NUMBERS(
    "number" = "<number>"
    [, "<const_value>" = "<const_value>" ]
  );

Required Parameters

Field	Description
number	The number of rows

Optional Parameters

Field	Description
const_value	Specifies the constant value generated

Return Value

Field	Type	Description
number	BIGINT	The value returned for each row

Examples

select * from numbers("number" = "5");

+--------+
| number |
+--------+
|      0 |
|      1 |
|      2 |
|      3 |
|      4 |
+--------+

select * from numbers("number" = "5", "const_value" = "-123");

+--------+
| number |
+--------+
|   -123 |
|   -123 |
|   -123 |
|   -123 |
|   -123 |
+--------+