GENERATE_SERIES

Generates a series of values from start to stop with a given step.

Analyze Syntax

func.generate_series(<start>, <stop>[, <step>])

Analyze Examples

func.generate_series(1, 5)

┌─────────────────┐
 [1, 2, 3, 4, 5]  
└─────────────────┘

SQL Syntax

GENERATE_SERIES(<start>, <stop>[, <step>])

SQL Examples

SELECT * FROM TABLE(GENERATE_SERIES(1, 5));

┌───────────┐
 1
2
3
4
5  
└───────────┘