Re: Impossible Database Design?

>> 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 - 13:33:14 CEST