Update cursor - current of??

From: "MaFa" <mafalista(at)freemail(dot)hu>
To: "pgsql-novice(at)postgresql(dot)" <pgsql-novice(at)postgresql(dot)org>
Subject: Update cursor - current of??
Date: 2003-11-01 15:55:33
Message-ID: 002901c3a090$959831a0$490e030a@attila
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi All!

I had run into the following problem.
I created a function using cursors, but when I call it, it returns an
error....
I created a very simple "test" function - and the result is the same...
:-(((

The error message with the test function is the following:
------------------
ERROR: parser: parse error at or near "of" at character 49

WARNING: Error occurred while executing PL/pgSQL function proba
WARNING: line 10 at SQL statement
--------------------

Here is the source of my function:
--------------------
CREATE OR REPLACE FUNCTION "public"."proba" () RETURNS integer AS'
declare
n_id integer;
users_c cursor for select id from ugyfelek for update;

begin
open users_c;
loop
fetch users_c into n_id;
update users
set megj=''Something''
where current of users_c;
end loop;
close users_c;
return 1;
end;
'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
----------------------

It seems to be a problem with the "current of" clause. The table "ugyfelek"
has primary key...

Could you help me to solve this problem?

Thanks: MaFa

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message MaFa 2003-11-01 16:13:54 Update cursor - current of
Previous Message Michael Glaesemann 2003-11-01 07:28:34 Re: Exporting data from PostgreSQL