postgresql中实现oracle SYS_CONNECT_BY_PATH

oracle：

select sys_connect_by_path(t2.ID, '/') as PATH, t1.id 
            from HTD_DEVICETYPE_RELATION t1 
            inner join HTD_DEVICETYPE_RESOURCE t2 on t1.CHILD_RESOURCE_TYPE_ID = t2.ID 
            start with t1.parent_resource_type_id = 100 and t1.id > 1 connect by nocycle 
      prior t2.id = t1.parent_resource_type_id order by t1.id

postgresql：

with recursive r_table(path,cycle,t1id,t2id,parent_resource_type_id) as
(
     select array[t.t2id],false,t.t1id,t.t2id,parent_resource_type_id from 
     
     (select t1.id as t1id,t2.id as t2id,t1.parent_resource_type_id as parent_resource_type_id
     from HTD_DEVICETYPE_RELATION as t1 
     inner join HTD_DEVICETYPE_RESOURCE as t2 on 
     t1.CHILD_RESOU