Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 2DBEB475B6D; Tue, 20 Aug 2002 09:16:33 -0400 (EDT) Received: from mail.benoit-computers.com (ptr-207-54-114-165.ptr.terago.ca [207.54.114.165]) by postgresql.org (Postfix) with ESMTP id B7A28475AF9; Tue, 20 Aug 2002 09:16:26 -0400 (EDT) Received: from ([]) by mail.benoit-computers.com (Merak 4.4.2) with SMTP id DBFC9CCB; Tue, 20 Aug 2002 08:14:39 -0500 From: "Darrin Domoney" To: , , , , Subject: Event recurrence - in database or in application code ???? Date: Tue, 20 Aug 2002 08:15:48 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/222 X-Sequence-Number: 5337 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). Ideally I would like to be able to generate an event off a template appointment (initial appt) and have it schedule identical appointments hourly, daily, weekly, monthly, or by selectable range (ie: first tuesday every month). I would also like to have the capability to remove an appointment and leave others (much like using C pointers - I think)or to remove all (cascading delete). Any suggestions, etc gratefully appreciated. Darrin