create or replace function mmm() returns setof record as
'
declare
rec record;
begin FOR rec IN SELECT foo.fooid,foo.foosubid,foo.fooname ,people_data.dk_anrede,dk_name_firma FROM foo inner join people_data on foo.fooid = people_data.dk_id LOOP
RETURN next rec; END LOOP; return NULL;
end;'language 'plpgsql'; --这里调用刚写的函数
select * from mmm() a(fooid int4, foosubid int4,fooname text,dk_anrede varchar,dk_anred varchar);
'
declare
rec record;
begin FOR rec IN SELECT foo.fooid,foo.foosubid,foo.fooname ,people_data.dk_anrede,dk_name_firma FROM foo inner join people_data on foo.fooid = people_data.dk_id LOOP
RETURN next rec; END LOOP; return NULL;
end;'language 'plpgsql'; --这里调用刚写的函数
select * from mmm() a(fooid int4, foosubid int4,fooname text,dk_anrede varchar,dk_anred varchar);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货