having trouble w/ having clause...

Mike Diehl <jdiehl@sandia.gov>

From: Mike Diehl <jdiehl@sandia.gov>
To: pgsql-sql@postgresql.org
Date: 2002-05-08T20:58:59Z
Lists: pgsql-general, pgsql-sql
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