Re: 'Universal' schedule table defintion

I'd figure a look at some of those open source calendar/schedule/reminder
programs might be helpful. You could try using yahoo calendars for some
insight.

You should be able to describe the repeating and nonrepeating stuff -
monthly, weekly, every X day, every X etc.

But I have no idea how one would do stuff like new moon sightings
(start/end of Muslim fasts - national holidays in some places) though,
especially when it could depend on local atmospheric conditions where the
official sighting is done.

So I figure you'd always need a text field for notes e.g. "subject to change".

Universal looks difficult to me.

Link.

At 03:08 PM 2/13/03 -0800, Dennis Gearon wrote:

>Anyone ever seen a table definition for schedules that could handle the
>following:
>
>'Every 3rd Thurday, except for national holidays'
>'from 8 AM to 10PM, closed 12-1pm and 6-7pm'
>'The period of time Thursday the Xth, xxxx to Sunday the Yth, xxxx,
>    11am to 8pm Thursday and Friday, 8am to 6pm Saturday and Sunday'
>'Monday thru Friday 10-3pm' (my kind of hours!)
>
>Obviously, I can do this with the strings above, but there is now way that
>the database could
>search for occurences of those using the strings, unless I come up with a
>special 'schedule
>language' and write a function to use in the select statement, (which I
>may have to do anyway).
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html