Re: Impossible Database Design?

>> Using one table for Pattern/Repetition definitions and one for the actual generated single events? <<

I use a table of "ticks" and a VIEW based on he current date to generate all the minutes in a day. It is always current

CREATE VIEW TodayTicks(time_slot)
AS
SELECT CAST (CURRENT_DATE + INTERVAL tick MINUTE) AS TIMESTAMP )   FROM Ticks ;

You can modify this idea for the 19-year perpetual calendar cycle. Received on Sat May 20 2006 - 20:31:55 CEST