Move cursor

From: "FERREIRA William (COFRAMI)" <william(dot)ferreira(at)airbus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Move cursor
Date: 2005-03-08 15:23:37
Message-ID: 1904E3EB39448246A7ECB76DF34A70B00143B473@TOCOMEXC03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wes 2005-03-08 15:44:21 Re: Vacuum time degrading
Previous Message Howard Cole 2005-03-08 15:15:18 Re: Simple query takes 5+ minutes