From: Ian Barwick <barwick@gmx.net>
To: jdiehl@sandia.gov
To: pgsql-sql@postgresql.org
Subject: Re: having trouble w/ having clause...
Date: Thu, 9 May 2002 01:13:22 +0200
Message-ID: <200205090113.22872.barwick@gmx.net> (raw)
In-Reply-To: <20020507215118.239013F33@dominion.dyndns.org>
References: <Pine.LNX.4.44.0205080903080.11632-100000@bluebell.marzen.de>
<m3offqk7hw.fsf@varsoon.wireboard.com>
<20020507215118.239013F33@dominion.dyndns.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: barwick@gmx.net, jdiehl@sandia.gov
Subject: Re: having trouble w/ having clause...
In-Reply-To: <200205090113.22872.barwick@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox