Re: having trouble w/ having clause...

Yep, this fixed it.  Thanx,

On Wednesday 08 May 2002 05:13 pm, Ian Barwick wrote:
     > On Wednesday 08 May 2002 22:58, Mike Diehl 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
     >
     > See:
     >
     > http://www.postgresql.org/idocs/index.php?sql-select.html
     >
     > "output_name
     >
     >  Specifies another name for an output column using the AS clause. This
     > name is primarily used to label the column for display. It can also be
     > used to refer to the column's value in ORDER BY and GROUP BY clauses.
     > But the output_name cannot be used in the WHERE or HAVING clauses;
     > write out the expression instead."
     >
     > HTH
     >
     > Ian Barwick

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