Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!uninett.no!ntnu.no!not-for-mail
From: Jon Heggland <heggland@idi.ntnu.no>
Newsgroups: comp.databases.theory
Subject: Re: Database Design problem
Date: Wed, 30 Nov 2005 12:20:47 +0100
Organization: IDI/NTNU
Lines: 13
Message-ID: <MPG.1df7a96e8b72b51298971c@news.ntnu.no>
References: <1132848500.303575.282710@z14g2000cwz.googlegroups.com> <Xns971CD4EFCBA49garbleme4455656@80.5.182.99> <dmfvhg$g5o$1@domitilla.aioe.org> <MPG.1df63047a5b82f4c989714@news.ntnu.no> <dmi5v9$1r8$1@domitilla.aioe.org>
NNTP-Posting-Host: coleburn.idi.ntnu.no
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
X-Trace: orkan.itea.ntnu.no 1133349644 23008 129.241.111.99 (30 Nov 2005 11:20:44 GMT)
X-Complaints-To: usenet@itea.ntnu.no
NNTP-Posting-Date: Wed, 30 Nov 2005 11:20:44 +0000 (UTC)
User-Agent: MicroPlanet-Gravity/2.60.2060
Xref: dp-news.maxwell.syr.edu comp.databases.theory:34782

In article <dmi5v9$1r8$1@domitilla.aioe.org>, wallace.reis@gmail.com 
says...
> Jon Heggland wrote:
> > An exceedingly simple constraint will take care of that.
> 
> How would you do it?

In D4 syntax:

constraint DontPlayAgainstYourself
  hometeam <> awayteam
-- 
Jon