[email protected] 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
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs