having trouble w/ having clause...

From: Mike Diehl <jdiehl(at)sandia(dot)gov>
To: pgsql-sql(at)postgresql(dot)org
Subject: having trouble w/ having clause...
Date: 2002-05-08 20:58:59
Message-ID: 20020507215118.239013F33@dominion.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fran Fabrizio 2002-05-08 20:59:16 Re: Contrib reindex script:
Previous Message Ron Snyder 2002-05-08 20:39:14 Re: timestamp in 7.1 vs 7.2

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-05-08 21:00:30 Re: Performance on update from join
Previous Message Edipo Elder Fernandes de Melo 2002-05-08 20:48:34 Migrating from 7.1 to 7.2