Re: Syntac error

[Timo Erbach <postgresql@xxxxxxxxxxx>]

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general