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
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 |