This section describes functions that possibly return more
than one row. Currently the only functions in this class are
series generating functions, as detailed in Table 9-38.

Table 9-38. Series Generating Functions

Function

Argument Type

Return Type

Description

generate_series(start, stop)

int or bigint

setof int or setof bigint (same as argument type)

Generate a series of values, from start to stop
with a step size of one.

generate_series(start, stop,
step)

int or bigint

setof int or setof bigint (same as argument type)

Generate a series of values, from start to stop
with a step size of step.

When step is positive, zero rows
are returned if start is greater than
stop. Conversely, when step is negative, zero rows are returned if
start is less than stop. Zero rows are also returned for NULL inputs. It is an error for step to be zero. Some examples follow:

Submit correction

If you see anything in the documentation that is not correct, does not match
your experience with the particular feature or requires further clarification,
please use
this form
to report a documentation issue.