Creating sequences in a query:

SELECT * FROM generate_series(1, 5) secu;

more ...