pgsql: Fix SQL:2008 FETCH FIRST syntax to allow parameters.

Поиск
Список
Период
Сортировка
Искать

pgsql: Fix SQL:2008 FETCH FIRST syntax to allow parameters.

От:
Andrew Gierth <rhodiumtoad@postgresql.org>
Дата:
Fix SQL:2008 FETCH FIRST syntax to allow parameters.

OFFSET  ROWS FETCH FIRST  ROWS ONLY syntax is supposed to accept
, which includes parameters as well as
literals. When this syntax was added all those years ago, it was done
inconsistently, with  and  being different subsets of the
standard syntax.

Rectify that by making  and  accept the same thing, and allowing
either a (signed) numeric literal or a c_expr there, which allows for
parameters, variables, and parenthesized arbitrary expressions.

Per bug #15200 from Lukas Eder.

Backpatch all the way, since this has been broken from the start.

Discussion: https://postgr.es/m/877enz476l.fsf@news-spur.riddles.org.uk
Discussion: http://postgr.es/m/152647780335.27204.16895288237122418685@wrigleys.postgresql.org

Branch
------
REL9_4_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/769e6fcd1a350ad3720030bcfa00d8c7ec9cf970

Modified Files
--------------
doc/src/sgml/ref/select.sgml | 14 +++++++------
src/backend/parser/gram.y    | 49 +++++++++++++++++++++++++++++---------------
2 files changed, 41 insertions(+), 22 deletions(-)

FAQ