Re: Update cursor - current of?? - Mailing list pgsql-novice

From Bruce Momjian
Subject Re: Update cursor - current of??
Date
Msg-id 200311062329.hA6NTQ212460@candle.pha.pa.us
Whole thread Raw
In response to Update cursor - current of??  ("MaFa" <mafalista@freemail.hu>)
List pgsql-novice
We don't support WHERE CURRENT OF yet.

---------------------------------------------------------------------------

MaFa wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-novice by date:

Previous
From: Boris Popov
Date:
Subject: Help with "locking" please
Next
From: "Louise Cofield"
Date:
Subject: Createdb Problems