Re: remove undocumented assign syntax from plpgsql doc - Mailing list pgsql-docs

From Pavel Stehule
Subject Re: remove undocumented assign syntax from plpgsql doc
Date
Msg-id CAFj8pRC_cRhpH3q-OHvUVrc0iX_zrDEKOXJgQ=U7U8jjgpgG+A@mail.gmail.com
Whole thread Raw
In response to Re: remove undocumented assign syntax from plpgsql doc  (Bruce Momjian <bruce@momjian.us>)
Responses Re: remove undocumented assign syntax from plpgsql doc  (Bruce Momjian <bruce@momjian.us>)
List pgsql-docs



2014/1/15 Bruce Momjian <bruce@momjian.us>
On Wed, Jan 15, 2014 at 04:55:11PM +0100, Pavel Stehule wrote:
>     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, patch updated.

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 :="

FOR statement nor OPEN statement doesn't use ":="

Regards

Pavel


--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: remove undocumented assign syntax from plpgsql doc
Next
From: Bruce Momjian
Date:
Subject: Re: remove undocumented assign syntax from plpgsql doc