CREATE TABLE emp
(
empno int,
empname varchar(100),
city varchar(100)
);
ALTER TABLE emp
ADD CONSTRAINT empno_pk PRIMARY KEY (empno);
INSERT INTO empCreate function:
select q.c as empno, 'testemp_'||q.c as empname, 'testcity_'||q.c as city
FROM
(SELECT generate_series(1,100) as c) AS q
;
CREATE FUNCTION reffunc(refcursor) RETURNS refcursor AS $$Get number of rows return:
BEGIN
OPEN $1 FOR
SELECT *
FROM emp
;
RETURN $1;
END;
$$ LANGUAGE plpgsql;
DECLAREFurther Study:
i INT;
BEGIN;
SELECT reffunc('funccursor');
MOVE ALL IN funccursor;
COMMIT;
http://www.postgresql.org/docs/current/static/sql-move.html