CREATE OR REPLACE FUNCTION prueba_cursor(codigo integer, curCursor refcursor)
RETURNS SETOF refcursor AS
$BODY$
DECLARE
cur alias for $2;
BEGIN
PERFORM mpf.ConstruyeCursorDesdeQuery('cur' ,'SELECT * from
tab1 WHERE field < 11000');
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;
CREATE OR REPLACE FUNCTION construyecursordesdequery(refcursor, query text)
RETURNS SETOF refcursor AS
$BODY$
BEGIN
OPEN $1 FOR Select * from tab1 where field < 11000;
RAISE NOTICE '%', $1;
RETURN NEXT $1;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100
ROWS 1000;
begin;
select * from prueba_cursor4(1, 'h');
end;
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador