Re: plpgsql: another new reserved word - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: plpgsql: another new reserved word
Date
Msg-id 162867790711091559p464f6594q2aa113055890be27@mail.gmail.com
Whole thread Raw
In response to plpgsql: another new reserved word  ("Marko Kreen" <markokr@gmail.com>)
Responses Re: plpgsql: another new reserved word  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 10/11/2007, Marko Kreen <markokr@gmail.com> wrote:
> I stumbled on another gotcha in 8.3's plpgsql:
>
> create or replace function foobar() returns text as $$
> declare
>     foobar  text;
> begin return 'ok'; end;
> $$ language plpgsql;
>
>
> Results in error:
>
> ERROR:  syntax error at or near "foobar"
> LINE 3:     foobar  text;
>             ^
>

It's label for function's parameters.

Pavel


> If this is intentional, then could the error message be made better?
>
> --
> marko
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


pgsql-hackers by date:

Previous
From: "Marko Kreen"
Date:
Subject: Re: Segmentation fault using digest from pg_crypto
Next
From: "Pavel Stehule"
Date:
Subject: Re: last note to rewrite function