952
社区成员
发帖
与我相关
我的任务
分享
declare
n integer:=0;--它老在这里说错误
begin
for n in 1 .. 1000 loop
insert into test values ( nextval('ql_job_seq'));
end loop;
end;
create function test() returns void as
$$
declare n integer :=0;
begin
while n <= 1000 loop
insert into test values ( nextval('ql_job_seq'));
n := n + 1;
end loop;
end;
$$ language plpgsql
select *,row_number() over() as rownum from test;
[/quote]
老大威武select *,row_number() over() as rownum from test;