Make a range in postgres

Question

Hi,

how can I make a range in a select in PostgreSQL ? I'd like to have this return:

num
---
1
2
3
4
5
6

In a query like:

SELECT range(1,6) AS num;

Answer 1

SELECT  *
FROM    generate_series(1, 6) num