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 NAA11282 for <postgres95@nobozo.CS.Berkeley.EDU>; Tue, 14 Nov 1995 13:26:47 -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 QAA01605; Tue, 14 Nov 1995 16:26:25 -0500
Received: (from jamiec@localhost) by interport.net (8.6.10/8.6.10) id PAA16115; Tue, 14 Nov 1995 15:58:30 -0500
Date: Tue, 14 Nov 1995 15:58:29 -0500 (EST)
From: jamie cohan <jamiec@interport.net>
To: "Andrew K. Yu" <andrew@postgres.Berkeley.EDU>
cc: drew@indirect.com, postgres95@postgres.Berkeley.EDU
Subject: Re: having count(*) > 1
In-Reply-To: <199510072358.QAA01312@eden.CS.Berkeley.EDU>
Message-ID: <Pine.SUN.3.91.951114155552.15474A-100000@interport.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Resent-To: postgres95-redist
Resent-Date: Tue, 14 Nov 95 13:26:48 -0800
Resent-From: pglite
Resent-XMts: smtp

I would like to volunteer for the 'fixing the having clause' contest.  
Does the parser need to be updated, does analyze.c need to be updated? 
All of the above, are there other files that also need updating?

On Sat, 7 Oct 
1995, Andrew K. Yu wrote:

> 
> > The following query should generate an error message and not
> > return incorrect results.
> > 
> > SELECT symbol, name
> >   FROM qm_hd
> >  GROUP BY symbol
> > HAVING count(*) > 1;
> 
> HAVING is not supported in version 1.0. (I ran out of time when I implement
> group by.) Everytime I was going to take it out, I kept thinking it's so
> close and some day it'll be fixed... any volunteers?
> 
> -andrew
> 
> 
> ===============================================================================
>   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/  ===========
> 

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