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: Question about Date & Darwen <OR> operator

Re: Question about Date & Darwen <OR> operator

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 2 Sep 2005 16:18:17 -0700
Message-ID: <1125703097.709646.6530@g49g2000cwa.googlegroups.com>

Marshall Spight wrote:
> Mikito Harakiri wrote:
> > Assuming domains x in {1,2} and y in {a,b} what is the result of
> >
> > {(x=1)} <OR> {(y=a)}
>
> As I understand it, the result would be:
>
> x y
> ---
> 1 a
> 1 b
> 2 a
>
>
> which is
> { (x, y) | x = 1 or y = a }

>From http://c2.com/cgi/wiki?RelationalAlgebra

a OR b : An extended form of union; if the headings of the operands differ, then "missing" attributes take on all possible values. Thus the result may be very large or even infinite. When the operands have the same heading, then this is the same as a traditional SQL UNION, except that all duplicates are always removed.

This informal description matches the other alternative. What is the formal definition? Received on Fri Sep 02 2005 - 18:18:17 CDT

Original text of this message

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