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 [EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
