pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: olivier.boissard@cerene.fr <olivier.boissard@cerene.fr>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: PostgreSQL Admin <pgsql-admin@postgresql.org>
Subject: Re: except command
Date: Tue, 14 Aug 2007 00:13:40 +0200
Message-ID: <46C0D794.3020105@cerene.fr> (raw)
In-Reply-To: <46C08CD6.EE98.0025.0@wicourts.gov>
References: <46C099F6.8050002@cerene.fr>
	<46C0579F.EE98.0025.0@wicourts.gov>
	<20070814061358.d66d2cb3.steve.holdoway@firetrust.com>
	<46C05C0C.EE98.0025.0@wicourts.gov>
	<46C0CD72.5090407@cerene.fr>
	<46C08CD6.EE98.0025.0@wicourts.gov>

Yes
 I noticed  It was not an ANSI sql operator
I think it's a good solution to spare temporay tables or result set

I was searching a way to ease some réplication scripts but I don't think 
it will help me.
It's better to use it to get a couple of records inside complex queries 
from many tables .

Thanks for help

Olivier

Kevin Grittner a écrit :
>>>> On Mon, Aug 13, 2007 at  4:30 PM, in message <46C0CD72.5090407@cerene.fr>,
>>>>         
> "olivier.boissard@cerene.fr" <olivier.boissard@cerene.fr> wrote: 
>   
>> So it's like a filter on the first query
>>     
>
> Exactly; I think that sums it up better than anything I said.
>  
> By the way, it does strike me as an odd omission that there is no set
> operator in the ANSI standard to get you directly to the set of disjoint
> elements.  With two datasets, a and b, you could always get there with:
>  
> (a EXCEPT b) UNION ALL (b EXCEPT a)
>  
> or with:
>  
> (a UNION ALL b) EXCEPT (a INTERSECT b)
>  
> Of course, you could store the sets in temporary tables to get there without
> generating from scratch each time, if that is expensive.
>  
> -Kevin
>  
>
>
>
>   




view thread (7+ messages)

Message-ID: <46C0D794.3020105@cerene.fr>
Permalink:  ../46C0D794.3020105@cerene.fr/
Also on:    postgresql.org/message-id/46C0D794.3020105@cerene.fr

 · 

reply

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-admin@postgresql.org
  Cc: olivier.boissard@cerene.fr, Kevin.Grittner@wicourts.gov
  Subject: Re: except command
  In-Reply-To: <46C0D794.3020105@cerene.fr>

* 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