semicolon not required on END statement

From: Hussein Patni <security(at)cosbit(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: semicolon not required on END statement
Date: 2004-09-30 15:11:44
Message-ID: 0AAE513F-12F3-11D9-83A1-000393BA421A@cosbit.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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Константин 2004-09-30 16:02:59 PLPGSQL and FOUND stange behaviour after EXECUTE
Previous Message Markus Bertheau 2004-09-30 08:16:28 Re: BUG #1271: Installation problems (cannot execute