Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c02.atl3!news.webusenet.com!syros.belnet.be!naxos.belnet.be!news.belnet.be!news.uia.ac.be!not-for-mail From: hidders@REMOVE.THIS.uia.ua.ac.be (Jan Hidders) Newsgroups: comp.databases.theory Subject: Re: Hotel Booking dates subquery Followup-To: comp.databases.theory Date: 11 Nov 2002 02:05:25 +0100 Organization: University of Antwerp Lines: 20 Message-ID: <3dcf0255$1@news.uia.ac.be> References: <5dkosuog0v9698ei9juhfbm2pull0nqqn2@4ax.com> <3dcecc70$1@news.uia.ac.be> Reply-To: hidders@uia.ua.ac.be (Jan Hidders) NNTP-Posting-Host: hnets.uia.ac.be X-Trace: naxos.belnet.be 1036976728 1779 143.169.254.1 (11 Nov 2002 01:05:28 GMT) X-Complaints-To: abuse@belnet.be NNTP-Posting-Date: Mon, 11 Nov 2002 01:05:28 +0000 (UTC) X-Newsreader: trn 4.0-test76 (Apr 2, 2001) Originator: hidders@hcoss.uia.ac.be (Jan Hidders) X-Original-NNTP-Posting-Host: hmacs.uia.ac.be X-Original-Trace: 11 Nov 2002 02:05:25 +0100, hmacs.uia.ac.be Xref: newsfeed1.easynews.com comp.databases.theory:23510 X-Received-Date: Sun, 10 Nov 2002 18:05:15 MST (news.easynews.com) Scotty wrote: > >Your test data has a big problem in that you have the same room being >used on conflicting dates: That is irrelevant because in this test we are only looking if periods overlap. The room number is immaterial for that. If it makes you nervous anyway you can renumber them 1 through 6. Please turn your brain back on because otherwise you will learn nothing and your instructor won't like that. >I'm curious to ask whether you think the theory behind my query works >or not, given test data that reasonable constraints would allow. Run the test and you will know. If it finds the right bookings your theory is correct, if it doesn't it's false. -- Jan Hidders