Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group