On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote: > > Hello Darrin, > <snip> > > I've been happy with this solution. I think the Perl turned out to be > fairly easy to understand and maintain, the SQL that needs to be used > ends up being fairly straightforward, and the performance is good > because the selects to view the calendar are fairly simple. The one > drawback is that sometime before 2028, I have to remember to add some > rows to the calendar table. :) >
You need to add rows as well as re-populate a bunch of info for recurring dates that are not listed forward right? > -mark > > http://mark.stosberg.com/ > > > On Tue, 20 Aug 2002, Darrin Domoney wrote: > > > One of the features that I am attempting to implement in the system that I > > am building is > > the capability to schedule events (with recurrence). My question to those of > > you that are > > more experienced in postgresql is whether you would implement this > > functionality in the > > database level using triggers or at the application code level (PHP). > > <snip> > > > > Any suggestions, etc gratefully appreciated. > > I would strongly recommend you look at the "WebCalendar" project on sourceforge. Robert Treat ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster