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 ------ master Details ------- https://git.postgresql.org/pg/commitdiff/1da162e1f5a783bd0ce26e6a07c0138dc8a47d44 Modified Files -------------- doc/src/sgml/ref/select.sgml | 10 +++++---- src/backend/parser/gram.y | 49 +++++++++++++++++++++++++++++--------------- 2 files changed, 39 insertions(+), 20 deletions(-)
