Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Curious SQL question

Re: Curious SQL question

From: Lennart <Erik.Lennart.Jonsson_at_gmail.com>
Date: 6 Jan 2007 09:49:26 -0800
Message-ID: <1168105766.201717.136400@s80g2000cwa.googlegroups.com>

Walt wrote:
[...]
>
> XOR (A,B) = MINUS ( UNION (A,B), INTERSECTION (A,B))
>
> Is this true? Is it a working definition?

That is one definition of symmetric difference, and I assume Bob choose that name because of another definition

    { x | x belongs to A XOR x belongs to B }

For the record, I don't understand the purpose of giving well defined operations new names, that at best will be confusing in its new context.

> Can it be transformed so that
> MINUS is defined in terms of XOR, UNION, and INTERSECTION?
>

Why not go all the way, XOR, OR and AND :-). Hmm, I cant come up with an expression for this without using NOT. Either its not possible, or I'm to stupid. I suspect the latter.

/Lennart Received on Sat Jan 06 2007 - 11:49:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US