PostgreSQL 函数中使用游标

Create or replace function test_cursor() returns void
as $$
declare
cur cursor for select id,name from test;--定义游标
m_id integer;
m_name character varying(20);
begin
open cur;--打开游标
loop
fetch cur into m_id,m_name;--读取游标
if not found then
exit;
end if;
insert into test2 values (m_id,m_name);
end loop;
end;
$$ language plpgsql

 

-执行函数

--select test_cursor()