From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Marko Kreen" <markokr(at)gmail(dot)com> |
Cc: | "Postgres Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: plpgsql: another new reserved word |
Date: | 2007-11-09 23:59:08 |
Message-ID: | 162867790711091559p464f6594q2aa113055890be27@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 10/11/2007, Marko Kreen <markokr(at)gmail(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-11-10 00:00:38 | Re: last note to rewrite function |
Previous Message | Marko Kreen | 2007-11-09 23:50:06 | Re: Segmentation fault using digest from pg_crypto |