Postgres Pro
Downloads
Home   >   mailing lists

Re: SCROLL CURSOR - Mailing list pgsql-general

From Tom Lane
Subject Re: SCROLL CURSOR
Date
Msg-id 27071.1223326003@sss.pgh.pa.us
Whole thread Raw
In response to SCROLL CURSOR  (<cyw@dls.net>)
List pgsql-general
Tree view 
<cyw@dls.net> writes:
> I declare a cursor as below:
>     DECLARE
>             links_cur SCROLL CURSOR IS SELECT * FROM road;
> and get this error:
>     CONTEXT:  invalid type name "SCROLL CURSOR IS SELECT * FROM road"

What PG version?  IIRC plpgsql didn't allow the SCROLL modifier there
before 8.3.

            regards, tom lane

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: feature idea
Next
From: Greg Smith
Date:
Subject: Re: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian