Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from park.interport.net (park.interport.net [199.184.165.2]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id MAA30429 for <postgres95@nobozo.CS.Berkeley.EDU>; Tue, 7 Nov 1995 12:14:38 -0800
Received: from interport.net (madison.nfs.interport.net [205.161.144.1]) by park.interport.net (8.6.11/8.6.11) with ESMTP id PAA00067 for <postgres95@nobozo.CS.Berkeley.EDU>; Tue, 7 Nov 1995 15:14:32 -0500
Received: (from jamiec@localhost) by interport.net (8.6.10/8.6.10) id OAA04366; Tue, 7 Nov 1995 14:47:25 -0500
Date: Tue, 7 Nov 1995 14:47:25 -0500 (EST)
From: jamie cohan <jamiec@interport.net>
To: postgres95@postgres.Berkeley.EDU
Subject: Patch for DECLARE .. GROUP BY
Message-ID: <Pine.SUN.3.91.951107144428.28052B-100000@interport.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres95-redist
Resent-Date: Tue, 07 Nov 95 12:14:39 -0800
Resent-From: pglite
Resent-XMts: smtp

Here is a patch for DECLARE .. GROUP BY. Special thanks to 
Andrew for his help.  Looking forward to postgres96.
 

===================================================================
RCS file: src/backend/nodes/RCS/parsenodes.h,v
retrieving revision 1.1
diff -r1.1 src/backend/nodes/parsenodes.h
464a465
>     List		*groupClause;	/* jamie group by clause */
===================================================================
RCS file: src/backend/parser/RCS/analyze.c,v
retrieving revision 1.1
diff -r1.1 src/backend/parser/analyze.c
509a510,518
> 
> 
> 
> 
>     /* fix group by clause */
>     qry->groupClause = transformGroupClause(pstate,
> 					    stmt->groupClause);
> 
> 
510a520
> 
===================================================================
RCS file: src/bin/psql/RCS/psqlHelp.h,v
retrieving revision 1.1
diff -r1.1 src/bin/psql/psqlHelp.h
76c76
<       "declare <portalname> [binary] cursor for\n\tselect [distinct]\n\t<expr1> [as <attr1>],...<exprN> [as <attrN>]\n\t[from <from_list>] [where <qual>]\n\t[order by <attr1> [using <op1>],... <attrN> [using <opN>]];"},
---
>       "declare <portalname> [binary] cursor for\n\tselect [distinct]\n\t<expr1> [as <attr1>],...<exprN> [as <attrN>]\n\t[from <from_list>] [where <qual>]\n\t[group by <attr1>]\n\t[order by <attr1> [using <op1>],... <attrN> [using <opN>]];"},
===================================================================
RCS file: src/backend/parser/RCS/gram.y,v
retrieving revision 1.1
diff -r1.1 src/backend/parser/gram.y
1343c1343
< 	     from_clause where_clause sort_clause
---
> 	     from_clause where_clause group_clause sort_clause
1364c1364,1365
< 		    n->orderClause = $11;
---
> 		    n->groupClause = $11;
> 		    n->orderClause = $12;

===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========