diff options
| author | Marc G. Fournier <scrappy@hub.org> | 1996-08-06 16:27:59 +0000 |
|---|---|---|
| committer | Marc G. Fournier <scrappy@hub.org> | 1996-08-06 16:27:59 +0000 |
| commit | ab22b34891b9b9002f302710facd110ac4af7657 (patch) | |
| tree | 831f9a04dd467c77bcdc1ed10e703d40a8b5f580 /src/backend/nodes/parsenodes.h | |
| parent | c4e53a14110816d0d495bb7f00cb4e3bdee3f123 (diff) | |
| download | postgresql-ab22b34891b9b9002f302710facd110ac4af7657.tar.gz postgresql-ab22b34891b9b9002f302710facd110ac4af7657.zip | |
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>
Diffstat (limited to 'src/backend/nodes/parsenodes.h')
| -rw-r--r-- | src/backend/nodes/parsenodes.h | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/backend/nodes/parsenodes.h b/src/backend/nodes/parsenodes.h index bc994bb1a0a..ff5baea9f1b 100644 --- a/src/backend/nodes/parsenodes.h +++ b/src/backend/nodes/parsenodes.h @@ -6,7 +6,7 @@ * * Copyright (c) 1994, Regents of the University of California * - * $Id: parsenodes.h,v 1.1.1.1 1996/07/09 06:21:33 scrappy Exp $ + * $Id: parsenodes.h,v 1.2 1996/08/06 16:27:48 scrappy Exp $ * *------------------------------------------------------------------------- */ @@ -462,6 +462,7 @@ typedef struct CursorStmt { List *targetList; /* the target list (of ResTarget) */ List *fromClause; /* the from clause */ Node *whereClause; /* qualifications */ + List *groupClause; /* group by clause */ List *orderClause; /* sort clause (a list of SortBy's) */ } CursorStmt; |