create or replace function get_tree(_idup int4) returns setof integer as
$$
declare 
   id_ int4;
   rec_ "Tree"%ROWTYPE;
begin
  raise notice '1';
  id_ = _idup;
  for rec_ in select * from "Tree" where idup = id_ loop
	  raise notice '2';
	  explain select * from get_tree (rec_.id);
	  return next rec_.id;
  end loop;
end;
$$
language 'plpgsql';

create or replace function get_tree(_idup int4, flag int4) returns setof integer as
$$
declare 
   id_ int4;
   rec_ "Tree"%ROWTYPE;
   rec1_ "Tree"%ROWTYPE;
begin
  if flag <>  0  then
     id_ = _idup;
     return next id_;
  end if;
   for rec_ in select * from "Tree" where idup = _idup loop
          for rec1_ in select * from get_tree (rec_.id,  1 ) loop
	   return next rec1_.id;
          end loop; 
  end loop;
end;
$$
language 'plpgsql';

select a.id, a.name, a.idup from "Tree" as a
	inner join get_tree( 1 ,  0 ) as b on a.id = b;