CONNECT BY postgres

Question

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;

score 2 · Accepted Answer · 2019-08-28 09:18:03Z

2

You can use generate_series()

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

edited Aug 28, 2019 at 9:18

answered Aug 28, 2019 at 9:14

user330315

Sign up to request clarification or add additional context in comments.

3 Comments

Z.Szymon Over a year ago

Awesome, as soon as I will be able to accept this answer I will do that.

Z.Szymon Over a year ago

Is there any way to pass this function dynamic value. For example subquery output?

user330315 Over a year ago

@Z.Szymon: yes, that's possible. It's a regular (set returning) function.

Collectives™ on Stack Overflow

CONNECT BY postgres

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related