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
>
>
>
>
>
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