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 |
+--------+