| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: More on lists and sets
Mikito Harakiri wrote:
> Mikito Harakiri wrote:
> > Definition. List intersection is a cartesian product with equijoin of
> > the list nodes and lexicographic order. Example: 1->2->1 /\ 2->1->2 =
> > 2->1->1->2
> >
> > 2 2
> > ^ ^
> > | \
> > 1 1 ------> 1
> > ^ ^
> > | \
> > 2 2
> > 1 -> 2 -> 1
> >
>
> This is actually amusing. Selection from list is join of two lists.
It just occured to me that conventional meaning of join of two lists is their concatenation. The conventional terminology is absurd, of course. Join is intersection and list intersection is quite different from list concatenation.
> As
> join/intersection is noncommutative, we have left selection and right
> selection. Example:
>
>
>
>
>
>
>
>
>
To add to this, list selection with equality predicate is commutative. Received on Mon Mar 20 2006 - 20:59:22 CST
![]() |
![]() |