Re: Bidirectional Binary Self-Joins
From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Sat, 31 Mar 2007 11:08:07 +0200
Message-ID: <460e2482$0$336$e4fe514c_at_news.xs4all.nl>
>
> Whether it complained or not would depend on the keys and other
> constraints.
> In another subthread I proposed the following key:
>
> (date, π_team(teamscores))
} Received on Sat Mar 31 2007 - 11:08:07 CEST
Date: Sat, 31 Mar 2007 11:08:07 +0200
Message-ID: <460e2482$0$336$e4fe514c_at_news.xs4all.nl>
Marshall wrote:
> Bob Badour wrote:
>> It would use the equality operation to detect the duplicate. What's more >> disturbing is it would allow the following without complaint: >> >> { date=12-Dec, teamscores={(team=Calvin, score=31), (team=Hope, score=59) }}
>
> Whether it complained or not would depend on the keys and other
> constraints.
> In another subthread I proposed the following key:
>
> (date, π_team(teamscores))
... allowing (using Bob's tag-notation):
{ date=12-Dec, teamscores={(team=Calvin, score=31),
(team=Hope, score=59),
(team=Glory, score=71)
}
} Received on Sat Mar 31 2007 - 11:08:07 CEST