Sorry, this was my mistake. If i just spent 60 more seconds reading the rules properly I would have seen this.
Although... it has bought up another possible bug with docs. The "Report an error" box (which I used to send the original message) seems to not be escaping HTML correctly... as seen in the previous message.
On 14 March 2017 at 1:28:37 PM, Tom Lane (tgl@sss.pgh.pa.us) wrote:
elliotchance@gmail.com writes:
> 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.
For some reason, the spec puts the CURSOR keyword into <cursor
properties>, but it's definitely there:
<cursor properties> ::=
[ <cursor sensitivity> ] [ <cursor scrollability> ] CURSOR
[ <cursor holdability> ]
[ <cursor returnability> ]
regards, tom lane