semicolon not required on END statement

semicolon not required on END statement

Re: semicolon not required on END statement

On Fri, 2004-10-01 at 01:11, Hussein Patni wrote:
> I noticed in plpgsql that a semi colon is not always requiredafter
> the END statement.

Yeah, I've noticed this as well (although it doesn't appear to be
documented). Would we gain anything by enforcing this restriction? IMHO
not a lot...

-Neil

Re: semicolon not required on END statement

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

Re: semicolon not required on END statement

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 END that concludes a
	function does not require one.


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

Neil Conway wrote:
> 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... ]

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

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.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

Re: semicolon not required on END statement

Bruce Momjian wrote:
> 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 END that concludes a
> 	function does not require one.

Patch applied.

-Neil

Re: semicolon not required on END statement

Neil Conway  writes:
> On Fri, 2004-10-01 at 01:11, Hussein Patni wrote:
>> I noticed in plpgsql that a semi colon is not always requiredafter
>> the END statement.

> Yeah, I've noticed this as well (although it doesn't appear to be
> documented). Would we gain anything by enforcing this restriction? IMHO
> not a lot...

We specifically do not require a semicolon at the very end of the
function definition.  My recollection is that the plpgsql grammar did
originally enforce that, and we relaxed it because it confused people.
You have to admit that
	... END;';
is a bit odd-looking.

			regards, tom lane