passing cursors from one PL function to another

From: Martín Marqués <martin(dot)marques(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: passing cursors from one PL function to another
Date: 2011-08-26 00:46:30
Message-ID: CABeG9LtoB148j=nH-i+fcC9VoZV-9cYzijmgtCr7kh5nfu1dhA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2011-08-26 00:49:59 Re: passing cursors from one PL function to another
Previous Message hubert depesz lubaczewski 2011-08-25 20:53:18 Re: [GENERAL] pg_upgrade problem