Re: SCROLL CURSOR

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cyw(at)dls(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SCROLL CURSOR
Date: 2008-10-06 20:46:43
Message-ID: 27071.1223326003@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<cyw(at)dls(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-10-06 21:43:53 Re: Re: [Pkg-postgresql-public] Postgres major version support policy on Debian
Previous Message hubert depesz lubaczewski 2008-10-06 20:27:51 Re: feature idea