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
