Content-Type: text/plain;
  charset="iso-8859-1"
From: Mike Diehl <jdiehl@sandia.gov>
Reply-To: jdiehl@sandia.gov
To: "Ian Barwick" <barwick@gmx.net>, pgsql-sql@postgresql.org
Subject: Re: having trouble w/ having clause...
Date: Thu, 9 May 2002 13:21:42 -0600
References: <Pine.LNX.4.44.0205080903080.11632-100000@bluebell.marzen.de>
	<20020507215118.239013F33@dominion.dyndns.org>
	<200205090113.22872.barwick@gmx.net>
In-Reply-To: <200205090113.22872.barwick@gmx.net>
Organization: Sandia
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-Id: <20020508201406.6FC763FEF@dominion.dyndns.org>

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