CODEWITHSUNDEEP
sqlpostgresql
Z.Szymon
Z.Szymon

Reputation: 337

CONNECT BY postgres

Is there any way to write this query from oracle rdbms in postgres? What I care about it to have track of the iterations made(level) and to be able to iterate a particular number of times(10). 

SELECT LEVEL 
FROM dual
CONNECT BY LEVEL <= 10;

Upvotes: 0

Views: 63

Answers (1)

user330315
user330315

Reputation:

You can use generate_series()

select *
from generate_series(1,10) as t(nr)

Upvotes: 2

Related Questions