X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8321CD1B475 for ; Wed, 7 Jan 2004 06:09:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 53667-09 for ; Wed, 7 Jan 2004 02:09:02 -0400 (AST) Received: from smtp104.mail.sc5.yahoo.com (smtp104.mail.sc5.yahoo.com [66.163.169.223]) by svr1.postgresql.org (Postfix) with SMTP id B68F7D1B449 for ; Wed, 7 Jan 2004 02:09:00 -0400 (AST) Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login) by smtp104.mail.sc5.yahoo.com with SMTP; 7 Jan 2004 06:08:59 -0000 Message-ID: <001701c3d4e4$62fc4dc0$7502a8c0@hdsc.com> Reply-To: "Kumar" From: "Kumar" To: , "Peter Eisentraut" , "psql" References: <00a501c3d41b$2dc9a0e0$7502a8c0@hdsc.com> <200401061956.57063.peter_e@gmx.net> <200401061413.12096.josh@agliodbs.com> Subject: Re: Calendar Scripts - Quite a complex one Date: Wed, 7 Jan 2004 11:36:16 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/34 X-Sequence-Number: 16427 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" To: "Peter Eisentraut" ; "Kumar" ; "psql" 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