diff options
| author | Robert Haas | 2013-06-28 14:18:00 +0000 |
|---|---|---|
| committer | Robert Haas | 2013-06-28 15:11:00 +0000 |
| commit | 5893ffa79c03824f34ae3d37f211381fd1c17283 (patch) | |
| tree | acccee7c457ab0d8f2224323d0e1faef0e19c3b7 /src/test | |
| parent | 5ee73525d57380a55b5c87f8df1c30bd32fb98b3 (diff) | |
Make the OVER keyword unreserved.
This results in a slightly less specific error message when OVER
is used in a context where we don't accept window functions, but
per discussion, it's worth it to get the benefit of not needing
to reserve this keyword any more. This same refactoring will
also let us avoid reserving some other keywords that we expect
to add in upcoming patches (specifically, IGNORE, RESPECT, and
FILTER).
Troels Nielsen, with minor changes by me
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/window.out | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/window.out b/src/test/regress/expected/window.out index 752c7b42ff3..ecc1c2c6113 100644 --- a/src/test/regress/expected/window.out +++ b/src/test/regress/expected/window.out @@ -989,9 +989,9 @@ ERROR: window functions are not allowed in GROUP BY LINE 1: SELECT rank() OVER (ORDER BY 1), count(*) FROM empsalary GRO... ^ SELECT * FROM rank() OVER (ORDER BY random()); -ERROR: window functions are not allowed in functions in FROM +ERROR: syntax error at or near "ORDER" LINE 1: SELECT * FROM rank() OVER (ORDER BY random()); - ^ + ^ DELETE FROM empsalary WHERE (rank() OVER (ORDER BY random())) > 10; ERROR: window functions are not allowed in WHERE LINE 1: DELETE FROM empsalary WHERE (rank() OVER (ORDER BY random())... |