plpgsql: another new reserved word

From: "Marko Kreen" <markokr(at)gmail(dot)com>
To: "Postgres Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: plpgsql: another new reserved word
Date: 2007-11-09 23:47:06
Message-ID: e51f66da0711091547i723afe1dx7589a780b67b2154@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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;
^

If this is intentional, then could the error message be made better?

--
marko

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2007-11-09 23:50:06 Re: Segmentation fault using digest from pg_crypto
Previous Message Scott Marlowe 2007-11-09 23:43:43 Re: Is "query" a reserved word in 8.3 plpgsql?