Re: [SQL] Event recurrence - in database or in application code ????

2002-08-21 Thread Mark Stosberg
On 21 Aug 2002, Robert Treat wrote: > On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote: > > > > Hello Darrin, > > > > > > > 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 str

Re: [SQL] Event recurrence - in database or in application code ????

2002-08-21 Thread Robert Treat
On Tue, 2002-08-20 at 22:15, Mark Stosberg wrote: > > Hello Darrin, > > > 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

Re: [SQL] Event recurrence - in database or in application code ????

2002-08-20 Thread Mark Stosberg
Hello Darrin, I recently implemented what I would consider the "hard part" of a solution to this using Perl and Postgres. My solution handles multi-day events and recurring events, including events that are both multi-day and recurring. Here's an overview of how I did it: A table called "calend

[SQL] Event recurrence - in database or in application code ????

2002-08-20 Thread Darrin Domoney
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