Skip site navigation (1) Skip section navigation (2)

Re: Syntac error

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 (view raw or flat)
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
>   


In response to

pgsql-general by date

Next:From: Filip RembiałkowskiDate: 2008-11-25 12:33:07
Subject: Re: two or more pg installations running as the same user
Previous:From: A. KretschmerDate: 2008-11-25 11:55:23
Subject: Re: Syntac error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group