Syntac error

[Timo Erbach <postgresql@xxxxxxxxxxx>]

Hello,

I've defined the following function and get an syntac error whle compiling.
Whats the fault?

CREATE FUNCTION "myscheme"."authenticate" () RETURNS 
"pg_catalog"."refcursor" AS
$body$
DECLARE
   curAccessRights refcursor;

BEGIN
   OPEN curAccessRights FOR
       SELECT * from myscheme."tblUsers";
      
   RETURN curAccessRights;
END;
$body$
LANGUAGE 'sql'

Regards Timo

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general