952
社区成员
发帖
与我相关
我的任务
分享请教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如何写？
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如何写？
...全文
请发表友善的回复…
发表回复
