Re: Impossible Database Design?

>> My conclusion would be that probably the best way would be to simply not support queries for predicting overlaps for dates without ending point.. <<

You can use a NULL end_date for an "eternity marker" then "COALESCE (end_date, CURRENT_DATE)" is a VIEW or queries for the current state of affairs. For longer term, use something like "COALESCE (end_date, (SELECT MAX(end_date FROM Calendar))".

You do not have to generate all the dates (which can only go to 9999-12-31 in ISO Standards), but just a subset of them as needed. The days-of-the week cycle is every 19 years (i Think) so you can use that fact to set your window. Received on Wed May 17 2006 - 13:58:41 CEST