generate_series

Return sequential numbers from the start to the stop values.

For an overview see page eXtremeSQL Functions

Prototype

     
    generate_series(start, stop);
     

Arguments

start	The first value in the generated series
stop	The last value in the generated series

Description

This function returns sequential numbers from the start to the stop value. It can be used to create a table with a single column that contains the generated values from the specified range.

Example

The generate_series() function can be called with code like the following:

 
    insert into foo  select s ."#1" from generate_series(1,100000) s;
    #1 
    --------------------------------------------------------
    1       
    2
    ...
    100000