| From: | Timo Erbach <postgresql(at)netbixx(dot)com> |
|---|---|
| To: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Syntac error |
| Date: | 2008-11-25 12:11:15 |
| Message-ID: | 492BEB63.6000907@netbixx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Filip Rembiałkowski | 2008-11-25 12:33:07 | Re: two or more pg installations running as the same user |
| Previous Message | A. Kretschmer | 2008-11-25 11:55:23 | Re: Syntac error |