Re: BUG #2494: SCROLL CURSOR does not worl

There's no such thing as a 'SCROLL CURSOR' in plpgsql:
http://www.postgresql.org/docs/8.1/interactive/plpgsql-cursors.html
I'm pretty sure that the default behavior would be scrollable.

We should probably add a TODO to bring the plpgsql cursor syntax inline
with what the backend supports.

On Fri, Jun 23, 2006 at 01:44:24PM +0000, Michal Szymanski wrote:
>
> The following bug has been logged online:
>
> Bug reference:      2494
> Logged by:          Michal Szymanski
> Email address:      biuro@globeinphotos.com
> PostgreSQL version: 8.1
> Operating system:   Windows
> Description:        SCROLL CURSOR does not worl
> Details:
>
> Function with scroll cursor  cannot be compiled.
> ERROR:  syntax error at or near "CURSOR"
> CONTEXT:  invalid type name "SCROLL CURSOR FOR SELECT * FROM freeconet.alias
> WHERE mask >"
> compile of PL/pgSQL function "dummy" near line 3
>
> Function that I want compile.
> CREATE OR REPLACE FUNCTION freeconet.dummy (
>                                  )    RETURNS INT8 AS $$
> DECLARE
> rowvar freeconet.ALIAS%ROWTYPE;
> DECLARE curs1  SCROLL CURSOR  FOR SELECT * FROM freeconet.alias WHERE
> mask>='+4850X' LIMIT 100 ;
> BEGIN
>     BEGIN
>
> OPEN curs1;
> FETCH curs1 INTO rowvar;
>
>     EXCEPTION
>     WHEN OTHERS THEN
>          RAISE WARNING '.... Kod bledu = %', SQLSTATE;
>              RETURN -1;   /* blad danych */
>     END;
>      RAISE WARNING ' mask=%',rowvar.mask;
>      RETURN 1;
> END;
> $$ LANGUAGE 'plpgsql' VOLATILE;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461