Build databases

Manage databases

Scripting

Private Cloud / On-Premises

Manage account

Resources

đź‘µ

Legacy documentation

Related Links

range

To return an array of consecutive numbers

With this function, you can define a **numeric value range** with a from-to specification. Where from might be set automatically to 0 if there is only one parameter.

The "from" value is **included** and the "to" value is **excluded**.

range(number)

range(number, number)

range(number, number, number)

[number]

`range(to)`

To return an array of consecutive numbers starting with 0 up or down to `to`

, where `to`

is excluded.concat(range(7))

â€‹

`range(from, to)`

To return an array of consecutive numbers from a range between `from`

and `to`

, where `from`

is included and `to`

is excluded. If `from`

is higher than `to`

the numbers will appear in reverse order.range(2,7)

â€‹

`range(from, to, step)`

To return an array of consecutive numbers from a range between `from`

and `to`

by a given step, where `from`

is included and `to`

is excluded. If `from`

is higher than `to`

the numbers will appear in reverse order.range(2, 9, 2)

Last modified 3mo ago

Export as PDF

Copy link

On this page

Syntax

Return

Examples

See also