semicolon not required on END statement

From: Hussein Patni <hussein(dot)patni(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: semicolon not required on END statement
Date: 2004-09-27 21:43:57
Message-ID: 5caf971e0409271443160913e2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello,

I noticed in plpgsql that a semi colon is not always required after
the END statement. A contrived example:

CREATE sequence foo;
 
CREATE OR REPLACE FUNCTION bar() RETURNS VOID AS '
DECLARE
bar int;
BEGIN
SELECT INTO bar nextval(''foo'');
RETURN;
END
' LANGUAGE plpgsql;

--hussein

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-09-27 23:09:13 BUG #1270: stack overflow in thread in fe_getauthname
Previous Message Tom Lane 2004-09-27 20:07:21 Re: Dollar quoting inside a regex bracket expression