Re: remove undocumented assign syntax from plpgsql doc
| От | Pavel Stehule |
|---|---|
| Тема | Re: remove undocumented assign syntax from plpgsql doc |
| Дата | |
| Msg-id | CAFj8pRC_cRhpH3q-OHvUVrc0iX_zrDEKOXJgQ=U7U8jjgpgG+A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: remove undocumented assign syntax from plpgsql doc (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: remove undocumented assign syntax from plpgsql doc
|
| Список | pgsql-docs |
2014/1/15 Bruce Momjian <bruce@momjian.us>
On Wed, Jan 15, 2014 at 04:55:11PM +0100, Pavel Stehule wrote:OK, patch updated.
> The problem is that these are philosophical issues that are not normally
> covered in our docs. What I have done is to add a mention of which
> option is compliant to the new text. Patch attached.
>
> Is GET DIAGNOSTICS defined in the standard for SQL/PSM only or for
> generic SQL?
>
>
>
> I found this statement in ANSI SQL 92 - and few minutes searching - it is in
> generic SQL - today "SQL framework" part and it is enhanced in "SQL/PSM"
ok
I don't understand last sentence of comment
! /*
! * Ada-based PL/SQL uses := for assignment and variable defaults, while
! * the SQL standard uses equals for these cases and for GET
! * DIAGNOSTICS, so we support both. FOR and OPEN only support :=.
! */
! assign_operator : '='
"FOR and OPEN only support :="
! /*
! * Ada-based PL/SQL uses := for assignment and variable defaults, while
! * the SQL standard uses equals for these cases and for GET
! * DIAGNOSTICS, so we support both. FOR and OPEN only support :=.
! */
! assign_operator : '='
"FOR and OPEN only support :="
FOR statement nor OPEN statement doesn't use ":="
Regards
Pavel
Pavel
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
В списке pgsql-docs по дате отправления: