From: elliotchance@gmail.com
To: pgsql-docs@postgresql.org
Subject: DECLARE syntax is different from the 2016 SQL standard
Date: Sun, 12 Mar 2017 06:09:37 +0000
Message-ID: <20170312060937.1416.26045@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.1/static/sql-declare.html
Description:
Hi,
The 2016 standard uses a different syntax to declare a cursor:
<declare cursor> ::=
DECLARE <cursor name> <cursor properties>
FOR <cursor specification>
Notice that it does not require or permit the "CURSOR" keyword before the
"FOR" keyword.
I don't know why this was changed and unfortunately fixing this would break
existing implementations, but there should be a note about this under the
SQL Standard section.
This was discovered with: https://github.com/elliotchance/sqltest
BNF for 2016 can be found in the same project:
https://github.com/elliotchance/sqltest/blob/master/standards/2016/bnf.txt#L2371-L2372
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
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: pgsql-docs@postgresql.org
Cc: elliotchance@gmail.com
Subject: Re: DECLARE syntax is different from the 2016 SQL standard
In-Reply-To: <20170312060937.1416.26045@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox