Re: Impossible Database Design?

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 17 May 2006 04:33:14 -0700
Message-ID: <1147865594.565512.291190@i40g2000cwc.googlegroups.com>

>> you can have

1. Infinite repeating events like "every year, every last monday,..." <<

Create a view which uses the CURRENT_DATE to get the year and to form a window of (-x, +x) years around it. I use this trick for a table of 5 second intervals in a day.

>> 2. The possibility to test whether events overlap other events <<

The usual way to do that is see if a calendar date falls between the start and end dates of more than one event. But you already know that a Monday event will not overlap a Tuesday event, July event will not overlap a June event, etc. Received on Wed May 17 2006 - 06:33:14 CDT