第2个回答 推荐于2017-10-01
create or replace function aa1(a1 char(10),a2 bigint) returns
void AS $$
declare ii integer;
begin
II:=1;
FOR ii IN 1..a2 LOOP
insert into user1 values(ii,a1);
end loop;
end;
$$ LANGUAGE plpgsql;
select aa1('a123',10)
or
create or replace function aa2(a1 char(10),a2 bigint) returns SETOF user1 AS $$
declare ii integer;
begin
II:=1;
FOR ii IN 1..a2 LOOP
insert into user1 values(ii,a1);
end loop;
return query SELECT * FROM user1;
end;
$$ LANGUAGE plpgsql;
select * from aa2('a123',20)