Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id A740D475A2B
	for <pgsql-sql@postgresql.org>; Mon, 13 May 2002 02:36:09 -0400 (EDT)
Received: from ebewe.com (unknown [80.120.1.196])
	by postgresql.org (Postfix) with ESMTP id 8021547598C
	for <pgsql-sql@postgresql.org>; Mon, 13 May 2002 02:34:21 -0400 (EDT)
Received: from exim by ebewe.com with spam-scanned (Exim 4.02)
	id 1778TS-00068E-00
	for pgsql-sql@postgresql.org; Mon, 13 May 2002 07:34:19 +0200
Received: from horn.intern.ebewe.at ([172.16.5.1] helo=mail.ebewe.co.at)
	by ebewe.com with esmtp (Exim 4.02)
	id 1778TP-000681-00; Mon, 13 May 2002 07:34:16 +0200
Subject: Re: having trouble w/ having clause...
To: jdiehl@sandia.gov
Cc: pgsql-sql@postgresql.org, pgsql-sql-owner@postgresql.org
X-Mailer: Lotus Notes Release 5.0.9  November 16, 2001
Message-ID: <OF83111100.01FEDB23-ONC1256BB8.0024281D@ebewe.co.at>
From: Wolfgang.Fuertbauer@ebewe.com
Date: Mon, 13 May 2002 08:35:19 +0200
X-MIMETrack: Serialize by Router on Unta_Notes_Srv01/EBEWE/AT(Release 5.0.9a
	|January 7, 2002) at 13.05.2002 08:35:20
MIME-Version: 1.0
Content-type: text/plain; charset=us-ascii
X-Scanner: exiscan for exim4 (http://duncanthrax.net/exiscan/)
	*1778TP-000681-00*x6iuhN6okkc*
X-Spam-Status: No, hits=0.8 required=5.0 tests=NO_REAL_NAME,AWL version=2.20
X-Spam-Level: 
X-Archive-Number: 200205/116
X-Sequence-Number: 7752


On 08.05.2002 22:58:59 pgsql-sql-owner wrote:
>Hi all,
>
>This is a simple question, but for the life of me, I can't see what is
wrong
>with this query:
>
>select host,slot,port,count(mac) as d from cam group by host,slot,port
having
>d>1;

try:
select host,slot,port,count(mac) as d from cam group by host,slot,port
having  count(mac) >1;
W

>
>I'm running 7.2.
>
>Thanx in advance,