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 VAA26227 for <postgres95@nobozo.CS.Berkeley.EDU>; Mon, 6 Nov 1995 21:08:24 -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 AAA28029 for <postgres95@nobozo.CS.Berkeley.EDU>; Tue, 7 Nov 1995 00:08:19 -0500
Received: (from jamiec@localhost) by interport.net (8.6.10/8.6.10) id AAA13192; Tue, 7 Nov 1995 00:08:17 -0500
Date: Tue, 7 Nov 1995 00:08:17 -0500 (EST)
From: jamie cohan <jamiec@interport.net>
To: postgres95@postgres.Berkeley.EDU
Subject: Is there a reason that DECLARE .. GROUP BY was not implemented
Message-ID: <Pine.SUN.3.91.951107000028.11830A-100000@interport.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres95-redist
Resent-Date: Mon, 06 Nov 95 21:08:25 -0800
Resent-From: pglite
Resent-XMts: smtp


Was there a reason that the followin statement " DECLARE mycursor cursor for 
select sum(a) from test group by a;" was not implemented.  I have 
modified 'gram.y' to allow for 'group_clause' and n->groupClause in the 
CursorStmt structure and modified 'nodes/parsernodes.h' to have a 
LList * groupClause.  What else should I modify to get this functionality.

Being able to have a cursor to return a GROUP BY is central to my 
application.  Could someone give me some guidance of how to add this 
functionality or give me a work around. I really need some help on this one.
Thanks

===============================================================================
  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/  ===========
