From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
---|---|
To: | Postgresql Novice List <pgsql-novice(at)postgresql(dot)org>, 'Rory Campbell-Lange' <rory(at)campbell-lange(dot)net> |
Subject: | Re: Fantasy Football complex select |
Date: | 2002-05-30 10:36:01 |
Message-ID: | 7DD34E6DF5CD1B4283DDAB96A855DCED2F33B2@vodabemail1.vodacom.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
try
SELECT sys_key FROM power GROUP BY sys_key HAVING count(*) > 4;
-----Original Message-----
From: Rory Campbell-Lange [mailto:rory(at)campbell-lange(dot)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(dot)l(dot)johnson(at)cox(dot)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(at)campbell-lange(dot)net>
<www.campbell-lange.net>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | V R | 2002-05-30 11:16:20 | Enabling Auditing in Postgres |
Previous Message | Henshall, Stuart - WCP | 2002-05-30 08:32:39 | Re: Fantasy Football complex select |