PostgreSQL 递归查询数据

MolinOne

于 2021-06-11 16:44:32 发布

阅读量205

点赞数

分类专栏： PostgreSQL

本文链接：https://blog.youkuaiyun.com/u010537432/article/details/117821832

版权

PostgreSQL 专栏收录该内容

1 篇文章

订阅专栏

查询子数据

 WITH RECURSIVE LE AS
(
 SELECT E1.* FROM "DATA_BDZ_RELATION_TEST" E1 WHERE E1."ID" = '30000476661838'
 UNION ALL
 SELECT E2.* FROM "DATA_BDZ_RELATION_TEST" E2,LE E3 WHERE E3."ID"=E2."PID"
)
 SELECT * FROM LE ;

查询父数据

 WITH RECURSIVE LE AS
(
 SELECT E1.* FROM "DATA_BDZ_RELATION_TEST" E1 WHERE E1."ID" = '30000476661838'
 UNION ALL
 SELECT E2.* FROM "DATA_BDZ_RELATION_TEST" E2,LE E3 WHERE E3."PID"=E2."ID"
)
 SELECT * FROM LE ;