56,677
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE FUNCTION getXXXList()
RETURNS SETOF record AS
$BODY$
DECLARE
result RECORD;
BEGIN
for result in
select field1,...
from table1...
LOOP
RETURN NEXT result;
END LOOP;
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION getXXXList() OWNER TO postgres;
CREATE OR REPLACE FUNCTION setXXXInfo()
RETURNS void AS
$BODY$
DECLARE
text_output varchar;
result RECORD;
BEGIN
for result in select * from getXXXXList() as (field1 numeric,field2 numeric,...);
LOOP
text_output := text_output || result .title || ''\n'';
END LOOP;
END
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ALTER FUNCTION setXXXInfo() OWNER TO postgres;
CREATE OR REPLACE FUNCTION setXXXInfo()
RETURNS void AS
$BODY$
DECLARE
text_output varchar;
result RECORD;BEGIN
for result in select * from geXXXXList() as (field1 numeric,field2 numeric,...);
LOOP
text_output := text_output || row_data.title || ''\n'';
END LOOP;
END
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100
ROWS 1000;
ALTER FUNCTION setXXXInfo() OWNER TO postgres;
function b
declare
myrec record;
...
begin
....
for myrec in select * from getXXXXXList() as (字段名称1 类型,字段名称2 类型,....)
loop
....
end loop;
....