求一个PostgreSQL的插入行的循环语句

[周江涛]

现在有一个表
create table User(
id int,
name varchar(32)
)
我现在想在C语言里调用执行sql，传入变量起始id号startid，和数量num，能够完成这一段号码的插入
类似于下面的伪代码
for ....
{
insert into User(id)
values(i)
}

[周江涛]

循环OK了，十分感谢

[WWWWA]

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)

[WWWWA]

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)

[周江涛]

我希望先从user1 的记录里取一个id最大值赋值给ii，再循环，该如何写呢？

[周江涛]

II:=select max(id) from UserTab; 这样有语法错误

[WWWWA]

II:=(select max(id) from UserTab);

[周江涛]

insert into UserTab(id) values(10000) 我先放一个数字在里面，再

[周江涛]

insert into UserTab(id) values(10000) 我先放一个数字在里面，再 create or replace function aa1(a1 char(10),a2 bigint) returns void AS $$ declare ii integer; begin II:=(select max(id) from UserTab); FOR ii IN 1..a2 LOOP insert into UserTab(id,name) values(ii+II,a1); end loop; end; $$ LANGUAGE plpgsql; select aa1('a123',10) 结果id值还是不对