elliotcha...@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 &quot;CURSOR&quot; keyword 
> before the
> &quot;FOR&quot; 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


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

Reply via email to