CONNECT BY LEVEL oracle -> postgresql

Oracle

SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= 10 ;

Postgresql

SELECT LEVEL FROM GENERATE_SERIES(1,10) LEVEL;