Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!news.nl.colt.net!newsgate.cistron.nl!feeder.enertel.nl!nntpfeed-01.ops.asmr-01.energis-idc.net!news-out1.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!teleglobe.net!62.81.31.29.MISMATCH!cyclone.auna.com!news-feeder.eresmas.com!news-reader.eresmas.com!not-for-mail From: Alfredo Novoa Newsgroups: comp.databases.theory Subject: Re: Translating constraints to RM Terms Message-ID: References: <1118042868.581634.304340@g47g2000cwa.googlegroups.com> <6erdn2-0nl.ln1@pluto.downsfam.net> X-Newsreader: Forte Free Agent 2.0/32.652 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 21 Date: Mon, 06 Jun 2005 16:17:54 +0200 NNTP-Posting-Host: 217.125.117.100 X-Complaints-To: abuse@eresmas.com X-Trace: news-reader.eresmas.com 1118068049 217.125.117.100 (Mon, 06 Jun 2005 16:27:29 MET DST) NNTP-Posting-Date: Mon, 06 Jun 2005 16:27:29 MET DST Organization: eresMas Xref: dp-news.maxwell.syr.edu comp.databases.theory:31247 On Mon, 06 Jun 2005 08:14:12 -0400, Kenneth Downs wrote: >Jonathan gave a pretty clear answer on type <> domain, Where? He said: column <> domain. Type and domain are almost always used as synonyms. > so I am with you so >far. Most importantly, the restatement of the question as relationship >twixt types and constraints is on the money. In my own mind I am also >asking if the constraint is a property of the column or the table. Your constraint is a property of the table because it is not a column type constraint. Regards