postgre存储过程加游标

CREATE OR REPLACE FUNCTION get_film_titles()
RETURNS text AS $$
– 声明游标
DECLARE
ids int4 default 703;
titles TEXT DEFAULT ‘’;
rec_film RECORD;
cur_films CURSOR FOR SELECT * FROM jobs ;
BEGIN

– 打开游标
OPEN cur_films ;

LOOP
– 获取记录放入film
FETCH cur_films INTO rec_film;
– exit when no more row to fetch
EXIT WHEN ids>990;
update sign set assignmentname = rec_film.station||’-’||rec_film.describe ,assignmentid = rec_film.id where id = ids;
ids = ids + 1;

     titles := titles || ',' || rec_film.id || ':' || rec_film.id;

END LOOP;

– 关闭游标
CLOSE cur_films;

RETURN titles;
END; $$

LANGUAGE plpgsql;