Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 8FC29476A1D
	for <pgsql-sql@postgresql.org>; Wed,  8 May 2002 17:15:51 -0400 (EDT)
Received: from smtp6.mindspring.com (smtp6.mindspring.com [207.69.200.110])
	by postgresql.org (Postfix) with ESMTP id E93D6476445
	for <pgsql-sql@postgresql.org>; Wed,  8 May 2002 16:44:22 -0400 (EDT)
Received: from user-38ldg5v.dialup.mindspring.com ([209.86.192.191]
	helo=dominion.dyndns.org)
	by smtp6.mindspring.com with esmtp (Exim 3.33 #1) id 175YIQ-0000XQ-00
	for pgsql-sql@postgresql.org; Wed, 08 May 2002 16:44:22 -0400
Received: from there (godzilla [10.0.1.2])
	by dominion.dyndns.org (Postfix) with SMTP id 239013F33
	for <pgsql-sql@postgresql.org>; Tue,  7 May 2002 17:51:17 -0400 (EDT)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Mike Diehl <jdiehl@sandia.gov>
Reply-To: jdiehl@sandia.gov
To: pgsql-sql@postgresql.org
Subject: having trouble w/ having clause...
Date: Wed, 8 May 2002 14:58:59 -0600
X-Mailer: KMail [version 1.3.1]
References: <Pine.LNX.4.44.0205080903080.11632-100000@bluebell.marzen.de>
	<m3offqk7hw.fsf@varsoon.wireboard.com>
In-Reply-To: <m3offqk7hw.fsf@varsoon.wireboard.com>
Organization: Sandia
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <20020507215118.239013F33@dominion.dyndns.org>
X-Archive-Number: 200205/59
X-Sequence-Number: 7695

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;

I'm running 7.2.

Thanx in advance,

-- 
Mike Diehl
Network Tools Devl.
Sandia Labs
(505) 284-3137