iterate over refcursor - Mailing list pgsql-general

From FERREIRA William (COFRAMI)
Subject iterate over refcursor
Date
Msg-id 1904E3EB39448246A7ECB76DF34A70B00143B46A@TOCOMEXC03
Whole thread Raw
List pgsql-general

hi

I got 2 functions write in pl/pgsql.
In the first function, i create a cursor and i need to use it into an other function
so the parameter is a refcursor.

the code :
        1st function :
DECLARE
        childCursor CURSOR FOR select * from ...
BEGIN
        SORT_CHILDREN(childCursor);
END;

        2nd function :
CREATE OR REPLACE FUNCTION SORT_CHILDREN(refCursor) RETURNS int4[] AS
$$
    DECLARE
      childCursor ALIAS FOR $1;
      childRecord adoc.xdb_child%ROWTYPE;
    BEGIN
        FOR childRecord IN childCursor LOOP
                ...
        END LOOP;
    RETURN ...;
END;
$$ LANGUAGE plpgsql;

But it doesn't work.....

My problem is : how to iterate over a refcursor in a function ?

thanks in advance

        Will

pgsql-general by date:

Previous
From: Sanjay Arora
Date:
Subject: RPM for whitebox linux - RH ES3 Clone
Next
From: John Sidney-Woollett
Date:
Subject: Re: problem with distinct rows