Re: union/difference/intersection question

From: Chris Withers <chris(at)simplistix(dot)co(dot)uk>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: union/difference/intersection question
Date: 2015-12-08 12:21:46
Message-ID: 5666CB5A.6030908@simplistix.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/12/2015 11:51, David Rowley wrote:
> On 9 December 2015 at 00:44, Chris Withers <chris(at)simplistix(dot)co(dot)uk
> <mailto:chris(at)simplistix(dot)co(dot)uk>> wrote:
>
> 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?
>
>
> Use UNION:
>
> select home_club from fixtures UNION select away_club from fixtures;

Fantastic, thanks.

That reminds me of a more general question, say I have a query which
returns:

key='a', value=1
key='b', value=2

...and another query, which returns:

key='b', value=3
key='c, value=4

(obviously the real world version of this has many more rows, and
indeed, more key columns and more value columns...)

So, ultimately I want to turn these two queries into inserts for keys
like 'a', updates for keys like 'b' and deletes for keys like 'c'.
What's the most efficient way of doing this? Three queries to get the
three sets, then a bulk insert, a set of updates and a bulk delete?

cheers,

Chris
>
> --
> David Rowley http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Training & Services
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Selim Tuvi 2015-12-08 16:50:20 Re: BDR: ALTER statement hanging
Previous Message David Rowley 2015-12-08 11:51:53 Re: aggregation question