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

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: why semicolon after begin is not allowed in postgresql?
Дата
Msg-id 1385422586132-5780250.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: why semicolon after begin is not allowed in postgresql?  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
Andrew Dunstan wrote
> 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?

Doh!

IF / THEN / ELSE / ENDIF .... (concept, not syntax)

That also does help to reinforce the point being made here...

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/why-semicolon-after-begin-is-not-allowed-in-postgresql-tp5779905p5780250.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: why semicolon after begin is not allowed in postgresql?
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Extension Templates S03E11