Move cursor

["FERREIRA William (COFRAMI)" <william.ferreira@xxxxxxxxxx>]

Title: iterate over refcursor

hi

 

i need to use the MOVE function on a cursor, for extracting special rows.

the function is written in pl/pgSQL

 

CREATE OR REPLACE FUNCTION TEST()
    RETURNS void AS $$
DECLARE

        childCursor CURSOR FOR select * from ... 
        childRecord adoc.xdb_child%ROWTYPE;

        dep int4 :=3;
BEGIN
    OPEN childCursor;

    LOOP

        MOVE FORWARD dep IN childCursor;
        FETCH childCursor INTO childRecord;

        EXIT WHEN not found;  
            raise notice '---> : % | % | %', childRecord.child_id, childRecord.evolution, childRecord.indx;

    END LOOP;
    CLOSE childCursor;

    RETURN void;
END;
$$ LANGUAGE plpgsql;

 

the function doesn't generate any error, but when i try to execute it, i get this message :

 

ERROR:  syntax error at or near "$1" at character 15
QUERY:  MOVE FORWARD  $1  IN  $2
CONTEXT:  PL/pgSQL function "test" line 10 at SQL statement

 

thanks in advance

 

 

    Will