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
>