Re: Scroll Cursor Bug?

Thanks for the response, Sim.

-  I forgot to include the BEGIN in the example I sent.  Even with the 
BEGIN, I get the same error.

-  I tried this with psql and you are right, the server spits back the 
message.  Therefore, I will move this to the postgres forum.

Thanks!


Sim Zacks wrote:
> 1) You don't have a Begin. The format is Declare then Begin and then
> lastly End
> 
> 2) My understanding is that these error messages would come directly from the
> server and not the query tool. Have you tried running the same query
> using psql?
> 
> Sim Zacks
> 
> ________________________________________________________________________________
> 
> Hi, I am hitting an issue when using SCROLL CURSORS.
> 
> My Setup:
> -  WinXP running PGAdminIII v1.2.2
> -  PostgreSQL 8 Server
> 
> 
> 
> My Test Function:
> 
> CREATE OR REPLACE FUNCTION DemoFunction () RETURNS varchar(50) AS
> $$
>         DECLARE CursorProductGroups SCROLL CURSOR FOR SELECT * FROM TEST_TABLE;
>         RETURN NULL;
> END;
> $$
> LANGUAGE plpgsql
> ;
> 
> 
> The Error that the Query Tool spits out:
> ERROR:  syntax error at or near "CURSOR"
> CONTEXT:  invalid type name "SCROLL CURSOR FOR SELECT * FROM TEST_TABLE"
> compile of PL/pgSQL function "demofunction" near line 1
> 
> It seems like the Query Tool has a bug with this because my demo looks 
> just like the examples given in the PostgreSQL documentation.
> 
> Any ideas?
> 
> Larry Morroni
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>