Re: [DOCS] DECLARE syntax is different from the 2016 SQL standard - Mailing list pgsql-docs

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