Postgresql游标CURSOR

最新推荐文章于 2024-01-30 14:09:42 发布

weixin_33727510

最新推荐文章于 2024-01-30 14:09:42 发布

阅读量302

点赞数

文章标签：数据库 java python

原文链接：https://my.oschina.net/wangchuandui/blog/820530

版权

2019独角兽企业重金招聘Python工程师标准>>>

CREATE OR REPLACE FUNCTION cursor_demo()  
  RETURNS refcursor AS  
$BODY$  

DECLARE 

cur CURSOR FOR select id , totalspace from aaa where discardflag = '0';
	v_id int;
	v_totalspace int;
begin
  open cur;
  FETCH  cur into v_id,v_totalspace ;
  while found loop
    insert into a values (v_id,v_totalspace);
	  FETCH next from  cur into v_id,v_totalspace ;

  end loop;
  RETURN cur ;
  close cur;
END;
$BODY$  
  LANGUAGE plpgsql;

转载于:https://my.oschina.net/wangchuandui/blog/820530