Re: why semicolon after begin is not allowed in postgresql?

On 11/25/2013 06:13 PM, David Johnston wrote:


>
> A side observation: why does "DECLARE" not require a block-end keyword but
> instead "BEGIN" acts as effectively both start and end?  BEGIN, IF, FOR,
> etc... all come in pairs but DECLARE does not.
>
>


A complete block is:
    [ DECLARE declarations ]    BEGIN statements    [ EXCEPTIONS handlers ]    END

The declare and exceptions parts are optional, as indicated. Does that 
make it clearer?


cheers

andrew