请教PostgreSQL与ORACLE兼容的问题——递归查询sql
Oracle的sql:
select t.org_id,
t.org_name,
t.org_level,
connect_by_root(org_id) org_up_id,
connect_by_root(org_name) org_up_name,
connect_by_root(org_level) org_level,
connect_by_isleaf leaf
from dm_org t
connect by prior t.org_id=decode(t.org_up_id , t.org_id , 0 , t.org_up_id);
请教各位大神,此段sql用PostgreSQL如何写?