Hi, The complexity comes while scheduling the appointments. Let us say, I have scheduled so many meetings in my calendar of various schedules like daily, 3 days once, weekly, bi weekly. monthly, bi monthly, etc.
While I open the calendar for end of this year (say Dec 2004), I need to show those meetings in my calendar, but I have data until Jan 2004. What is the best way to show it. Populating the records from Jan 2004 to Dec 2004 in the pgsql function and display it in the calendar, or just write a query to generate temporary records only for that Dec 2004 and not storing them at the database. Please shed some idea. Regards Kumar ----- Original Message ----- From: "Josh Berkus" <[EMAIL PROTECTED]> To: "Peter Eisentraut" <[EMAIL PROTECTED]>; "Kumar" <[EMAIL PROTECTED]>; "psql" <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 3:43 AM Subject: Re: [SQL] Calendar Scripts - Quite a complex one Peter, > You can probably lift out the complete calendar functionality from an > existing groupware solution, say, www.egroupware.org. I'm not sure > whether it's practical to do the calendar things in the database, since > you will also need a significant amount of intelligence in the client > to display reasonable calendar graphics, for instance. But all of the appointments, holidays, etc can and should be stored in the database, and by using function programming one can automate generating all of the raw data for the calendar graphics. We do this with our legal calendaring app. -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
