Re: Syntac error - Mailing list pgsql-general

From Timo Erbach
Subject Re: Syntac error
Date
Msg-id 492BEB63.6000907@netbixx.com
Whole thread Raw
In response to Re: Syntac error  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List 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
>


pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Syntac error
Next
From: "Filip Rembiałkowski"
Date:
Subject: Re: two or more pg installations running as the same user