Postgresql递归查询

数据表

with RECURSIVE cte as 
 ( 
 select a.* from department a where name='东南片区' 
  union all  
  select k.*  from department k inner join cte c on c.name = k.parent_dep 
 )select * from cte;