public inbox for [email protected]  

help / color / mirror / Atom feed
From: Pavel Stehule <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: remove undocumented assign syntax from plpgsql doc
Date: Wed, 15 Jan 2014 17:39:22 +0100
Message-ID: <CAFj8pRC_cRhpH3q-OHvUVrc0iX_zrDEKOXJgQ=U7U8jjgpgG+A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<CAFj8pRAyAOi9ZJbxMBPkW+r03n+zQm6idojWWH2n17h8NGyXBA@mail.gmail.com>
	<[email protected]>
	<CAFj8pRAPNM0__k9FsBJc1ubyHq8xoU0TxgoHdLEud7sV=OaTDA@mail.gmail.com>
	<[email protected]>
	<CAFj8pRAz=uZx4=egdrx1i3mHLSjBGtVb8+5DUY7tnCC=GNixDA@mail.gmail.com>
	<[email protected]>
	<CAFj8pRBRCNFjVGoMz-uVDJ3jZT5nO_5KQx4WuG20t+pzXKjEGA@mail.gmail.com>
	<[email protected]>
	<CAFj8pRCWRHFbi9FQcfHY++Yoy6s78Ph9Bs3jS_AJ2hgvvx1HLQ@mail.gmail.com>
	<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

2014/1/15 Bruce Momjian <[email protected]>

> 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  <[email protected]>        http://momjian.us
>   EnterpriseDB                             http://enterprisedb.com
>
>   + Everyone has their own god. +
>


view thread (27+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: remove undocumented assign syntax from plpgsql doc
  In-Reply-To: <CAFj8pRC_cRhpH3q-OHvUVrc0iX_zrDEKOXJgQ=U7U8jjgpgG+A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox