PG返回记录的集合

实例

• 查询指定资源ID的组织下的子资源

create or replace function test_bl(v_res_id int)
returns setof tbl_res 
as
$BODY$
declare
  v_res_level  INT;
  rec tbl_res%rowtype;
begin
  select res_level into v_res_level from test where res_id=v_res_id;
  
  for rec in execute 'select * from test where res_tree_level'||v_res_level||'_id='||v_res_id||';'
  loop
    return next rec;
  end loop;
  return ;
END;
$BODY$
LANGUAGE 'plpgsql'；