all, I have logic in Oracle and should migrate to PostgreSQL. But the version of PostgreSQL doesn't support "with recursive" it's v.8.3. Can you help me?
BR
Oracle logic:
select
t1.re_id
from ib_re t1, ib_re_usage t2
Where t1.re_id = t2.re_id
Start with t1.re_id in (1035,1036)
Connect by parent_re_id = Prior t1.re_id