SQL · Array and set-returning functions

generate_series()

Generates a series of values. PostgreSQL; use a recursive CTE in SQLite.

sqlRunnable example sql course

Syntax

generate_series(start, stop, step)

Example

Open in the lab

WITH RECURSIVE series(n) AS (SELECT 1 UNION ALL SELECT n + 1 FROM series WHERE n < 5)
SELECT n FROM series;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.