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;
