having trouble w/ having clause... - Mailing list pgsql-sql

From Mike Diehl
Subject having trouble w/ having clause...
Date
Msg-id 20020507215118.239013F33@dominion.dyndns.org
Whole thread Raw
In response to Re: [GENERAL] Performance issues with compaq server  (Doug McNaught <doug@wireboard.com>)
Responses Re: having trouble w/ having clause...  (Ian Barwick <barwick@gmx.net>)
List 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


pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Bad performance on update from a join
Next
From: Edipo Elder Fernandes de Melo
Date:
Subject: Migrating from 7.1 to 7.2