Make a range in postgres
21,933
SELECT *
FROM generate_series(1, 6) num
https://www.postgresql.org/docs/current/functions-srf.html
Author by
Yuri Kaszubowski Lopes
Updated on April 17, 2020Comments
-
Yuri Kaszubowski Lopes about 4 years
How can I make a range in a select in PostgreSQL? I'd like to have this result:
num --- 1 2 3 4 5 6
From a query like:
SELECT range(1,6) AS num;