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
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 |