Fixes:
Marc G. Fournier <scrappy@hub.org>
Fixes: While a normal SELECT statement can contain a GROUP BY clause, a cursor declaration cannot. This was not the case in PG-1.0. Was there a good reason why this was changed? Are cursors being phased out? Is there any way to get data with just a SELECT (and without a DECLARE CURSOR ...)? The patch below seems to fix things. If anyone can see a problem with it, please let me know. Thanks. Submitted by: David Smith <dasmith@perseus.tufts.edu>
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/nodes/parsenodes.h | modified | +2 −1 |
| src/backend/parser/analyze.c | modified | +5 −1 |
| src/backend/parser/gram.y | modified | +4 −3 |