Return cursor

Carmen Gloria Sepulveda Dedes wrote:

Hi!

I need to return a cursor from a function/procedure?
How can I do it?

http://developer.postgresql.org/docs/postgres/plpgsql-cursors.html

Jan

Thanks,

CGS

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

CREATE FUNCTION reffunc2() RETURNS refcursor AS '
DECLARE
ref refcursor;
BEGIN
OPEN ref FOR SELECT col FROM test;
RETURN ref;
END;
' LANGUAGE 'plpgsql';

On Mon, 2003-08-25 at 17:05, Carmen Gloria Sepulveda Dedes wrote:

Hi!

I need to return a cursor from a function/procedure?
How can I do it?

Thanks,

CGS

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

--
Venlig hilsen / Best regards,
Jacob Vennervald
System Developer
Proventum Solutions ApS
Tuborg Boulevard 12
2900 Hellerup
Denmark
Phone: +45 36 94 41 66
Mobile: +45 61 68 58 51