try
SELECT sys_key FROM power GROUP BY sys_key HAVING count(*) > 4;
-----Original Message-----
From: Rory Campbell-Lange [mailto:rory@campbell-lange.net]
Sent: Wednesday, May 29, 2002 11:49 PM
To: Ron Johnson
Cc: Postgresql Novice List
Subject: Re: [NOVICE] Fantasy Football complex select
On 29/05/02, Ron Johnson (ron.l.johnson@cox.net) wrote:
> On Wed, 2002-05-29 at 04:18, Rory Campbell-Lange wrote:
> > I have the task of designing the office fantasy football system to run
> > on our intranet. The fantasy football game is a game centering around
> > the world cup football tournament.
>
> Hey, it's not football season!! That's not for 4 more months...
That isn't what most of the rest of the world thinks! But you can
convince me by telling me if I can do something like this:
select all the rows from a table except
(where there are 4 instances of this column).
(how is that for a 2 line summary of my last long question?!).
Thanks for any help.
Rory
--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html