Re: Impossible Database Design?

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Tue, 16 May 2006 19:31:43 GMT
Message-ID: <zMpag.8500$A26.215486@ursa-nb00s0.nbnet.nb.ca>

Nikolai Onken wrote:

> Kenneth Downs wrote:
>

>>Simple comparison of their endpoints determines if the intervals overlap.

>
>
> Yeah, so if I don't want endpoints (forever repeating events) I
> wouldn't be able to compare events. So I guess I have to decide whether
> I need functionality like 'do two repeating events overlap at any time
> they exist' or 'repeat every year until forever'.
> I am just curious to whether there is a middle way supporting both
> requirements (Though it doesn't make sense to me :) )

If one accepts the limitation of a finite representation, which in the end one has no choice over, then there will always be a finite endpoint at the extreme end of the representation. For a time representation, that might be 999999/12/31 or some other large finite value. Received on Tue May 16 2006 - 14:31:43 CDT