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 16:55:11 +0100
Message-ID: <CAFj8pRCWRHFbi9FQcfHY++Yoy6s78Ph9Bs3jS_AJ2hgvvx1HLQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<CAFj8pRDukaWkUtQRZujhbLRCh6haOY-FDunVXjf2X2XNdNOKGQ@mail.gmail.com>
	<[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]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

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

> On Wed, Jan 15, 2014 at 11:07:29AM +0100, Pavel Stehule wrote:
> >     I thought you would say that.  :-)  I don't see how this detail makes
> >     sense in the sections related to the syntax usage, so I looked in the
> >     section Porting from Oracle PL/SQL, and I don't see how it fits there
> >     either.
> >
> >
> >
> > :)
> >
> > just notice - sorry for my English
> >
> > ==Assign==
> > Using ":=" is preffered as assign statement due conformity with ADA
> language (a
> > plpgsql ancestor).
> >
> >
> > ==GET DIAGNOSTICS==
> >
> > Using "=" is highly preferred due conformity with ANSI/SQL
>
> 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"

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: <CAFj8pRCWRHFbi9FQcfHY++Yoy6s78Ph9Bs3jS_AJ2hgvvx1HLQ@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