[BUGS] semicolon not required on END statement

#1

Hello,

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

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

--hussein

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#2

Improved wording that doesn't telegraph, "Look at me!":

Each declaration and each statement within a block is terminated by a
semicolon, though the final <literal>END</literal> that concludes a
function does not require one.

---------------------------------------------------------------------------

Neil Conway wrote:

Quote:

On Fri, 2004-10-01 at 13:46, Tom Lane wrote:
We specifically do not require a semicolon at the very end of the
function definition.

Yeah, makes sense. Attached is a doc patch. Barring any objections I'll
apply it to HEAD by end-of-day today.

-Neil

[ Attachment, skipping... ]

Quote:

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

#3

Bruce Momjian wrote:

Quote:

Improved wording that doesn't telegraph, "Look at me!":

Each declaration and each statement within a block is terminated by a
semicolon, though the final <literal>END</literal> that concludes a
function does not require one.

Patch applied.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] semicolon not required on END statement

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] semicolon not required on END statement - 10-01-2004 , 08:36 AM

Re: [BUGS] semicolon not required on END statement - 10-01-2004 , 07:50 PM

Re: [BUGS] semicolon not required on END statement - 10-04-2004 , 12:43 AM