posgresql存储过程返回记录集
CREATE OR REPLACE FUNCTION glam_data.p_test_return_set_of_reocrd()
RETURNS setof glam_data.secu_basic_info AS
$BODY$
declare secu glam_data.secu_basic_info;
begin
for secu in select * from glam_data.secu_basic_info sbi loop
return next secu;
end loop;
end;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
直接查询
select * from glam_data.p_test_return_set_of_reocrd