aggregation question - Mailing list pgsql-general

From Chris Withers
Subject aggregation question
Date
Msg-id 5666C297.9010304@simplistix.co.uk
Whole thread Raw
Responses Re: aggregation question  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-general
Hi All,

I hope this is quite a simple one...

I have a fixtures table containing home_club and away_club, and I'd like
to select the distinct list of clubs contained in all rows but in either
the home_club or away_club columns.

How would I do that?

thanks for the help!

Chris




pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Packages for Ubuntu Wily (15.10)
Next
From: David Rowley
Date:
Subject: Re: aggregation question