Return-Path: owner-postman 
Delivery-Date: Tue, 03 May 94 16:36:07 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA06829 for postgres-redist; Tue, 3 May 1994 12:32:57 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405031932.MAA06829@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id MAA06819 for <postgres@postgres.Berkeley.EDU>; Tue, 3 May 1994 12:32:56 -0700
Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id MAA18217; Tue, 3 May 1994 12:31:47 -0700
Message-Id: <199405031931.MAA18217@faerie.CS.Berkeley.EDU>
X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
From: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
To: cs400514@comp.hkp.hk (Lee Siu Hoi (BACS4 Class A))
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: ?
Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki)
In-reply-to: Your message of Mon, 2 May 94 07:00:30 HKT 
	     <9405012300.AA13088@csun02.COMP.HKP.HK> 
Date: Tue, 03 May 94 12:31:47 -0700
X-Sender: aoki@postgres.Berkeley.EDU
Resent-To: postgres-redist@postgres.Berkeley.EDU
X-Mts: smtp
Resent-Date: Tue, 03 May 94 12:32:57 -0700
Resent-XMts: smtp

cs400514@comp.hkp.hk (Lee Siu Hoi (BACS4 Class A)) writes:
> It is legal to use aggregate function in the where statement?

this is documented in the reference manual as being broken.

> If no, any other approach can do the similar thing?
> I really need to make such queries.
> Any suggestion or hints will be appreciated.

i know an email address where you can send hate mail, but that's
about it at this point..
--
  Paul M. Aoki  |  CS Div., Dept. of EECS, UCB  |  aoki@postgres.Berkeley.EDU
                |  Berkeley, CA 94720           |  ...!uunet!ucbvax!aoki

===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================