Hi Andreas,
thank you!
I did install plpsql and now everything is fine.
Regards Timo
A. Kretschmer schrieb:
am Tue, dem 25.11.2008, um 12:41:32 +0100 mailte Timo Erbach folgendes:
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;
...
$body$
LANGUAGE 'sql'
You can't use declare in this language, use plpgsql instead.
Regards, Andreas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
