Added LIMIT/OFFSET functionality including new regression test for it.
Jan Wieck <JanWieck@Yahoo.com>
Added LIMIT/OFFSET functionality including new regression test for it. Removed CURRENT keyword for rule queries and changed rules regression accordingly. CURRENT has beed announced to disappear in v6.5. Jan
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/commands/command.c | modified | +20 −2 |
| src/backend/executor/execMain.c | modified | +131 −13 |
| src/backend/executor/functions.c | modified | +5 −2 |
| src/backend/executor/spi.c | modified | +37 −2 |
| src/backend/parser/analyze.c | modified | +5 −1 |
| src/backend/parser/gram.y | modified | +90 −5 |
| src/backend/parser/keywords.c | modified | +3 −4 |
| src/backend/rewrite/rewriteDefine.c | modified | +7 −1 |
| src/backend/tcop/pquery.c | modified | +7 −5 |
| src/include/executor/executor.h | modified | +3 −2 |
| src/test/regress/expected/limit.out | added | +106 −0 |
| src/test/regress/expected/rules.out | modified | +13 −13 |
| src/test/regress/sql/limit.sql | added | +31 −0 |
| src/test/regress/sql/rules.sql | modified | +13 −13 |
| src/test/regress/sql/tests | modified | +1 −0 |