postgres=# select * from generate_series(5,1,-2); generate_series ----------------- 5 3 1 (3 rows) postgres=#