Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from pop.sealink.com (root@pop.sealink.com [206.5.140.5]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id TAA17280 for <postgres95@postgres.berkeley.edu>; Mon, 6 Nov 1995 19:23:34 -0800
Received: from sealink.com (wwws.sealink.com [206.5.140.4]) by pop.sealink.com (8.6.9/8.6.9) with SMTP id UAA00282 for <postgres95@postgres.berkeley.edu>; Mon, 6 Nov 1995 20:28:08 -0800
Received: by sealink.com (5.x/SMI-SVR4)
	id AA01190; Mon, 6 Nov 1995 19:21:49 -0800
Date: Mon, 6 Nov 1995 19:21:49 -0800
From: scott@sealink.com (Scott Capedeville)
Message-Id: <9511070321.AA01190@sealink.com>
To: postgres95@postgres.Berkeley.EDU
Subject: Is there a reason that DECLARE .. GROUP BY .. was not implemented
X-Sun-Charset: US-ASCII
Resent-To: postgres95-redist
Resent-Date: Mon, 06 Nov 95 19:23:36 -0800
Resent-From: pglite
Resent-XMts: smtp

I executed the following:

BEGIN;
declare myportal cursor for select sum(a) from test group by a;

and got the message "parser error at or near 'group'"
was there a reason that group by was not implemented with DECLARE statements
when it is implemented in SELECT statements.  Also how can I fix the problem. 
I can add the functionality to 'gram.y' so that it can accept 'group_clause'
in CursorStmt: 

I will gladly fix the problem if fixing the problem is not a huge undertaking
Could anyone out there pass on some of there infinite wisdom. 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/  ===========
