Very Computer

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Quote:> 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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

Yep, this fixed it.  Thanx,

     > > 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Quote:>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;
W

Quote:

>I'm running 7.2.

>Thanx in advance,

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org