diff options
| author | Andrew Gierth <rhodiumtoad@postgresql.org> | 2018-05-21 17:02:17 +0100 |
|---|---|---|
| committer | Andrew Gierth <rhodiumtoad@postgresql.org> | 2018-05-21 17:27:08 +0100 |
| commit | 1da162e1f5a783bd0ce26e6a07c0138dc8a47d44 (patch) | |
| tree | 33ee0d0c53b3abef755704fddf4680a0db94e1c0 /src/backend/executor/nodeSort.c | |
| parent | 806d08c0489f72282e0a25629e0d6054176e0c9d (diff) | |
| download | postgresql-1da162e1f5a783bd0ce26e6a07c0138dc8a47d44.tar.gz postgresql-1da162e1f5a783bd0ce26e6a07c0138dc8a47d44.zip | |
Fix SQL:2008 FETCH FIRST syntax to allow parameters.
OFFSET <x> ROWS FETCH FIRST <y> ROWS ONLY syntax is supposed to accept
<simple value specification>, which includes parameters as well as
literals. When this syntax was added all those years ago, it was done
inconsistently, with <x> and <y> being different subsets of the
standard syntax.
Rectify that by making <x> and <y> 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
Diffstat (limited to 'src/backend/executor/nodeSort.c')
0 files changed, 0 insertions, 0 deletions