From sgnerd@yahoo.com.sg Mon Jan  5 11:07:52 2004
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 D8A84D1C979
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  5 Jan 2004 11:07:52 +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 45950-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  5 Jan 2004 07:07:06 -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 DEC86D1B976
	for <pgsql-sql@postgresql.org>; Mon,  5 Jan 2004 07:07:00 -0400 (AST)
Received: from unknown (HELO IVESIA67) (sgnerd@203.196.190.138 with login)
	by smtp104.mail.sc5.yahoo.com with SMTP; 5 Jan 2004 11:07:02 -0000
Message-ID: <012b01c3d37b$b95c54e0$7502a8c0@hdsc.com>
Reply-To: "Kumar" <sgnerd@yahoo.com.sg>
From: "Kumar" <sgnerd@yahoo.com.sg>
To: "psql" <pgsql-sql@postgresql.org>
Subject: Virtual records
Date: Mon, 5 Jan 2004 16:34:38 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0128_01C3D3A9.CFD6CB00"
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-Spam-Status: No, hits=0.7 tagged_above=0.0 required=5.0 tests=HTML_40_50
X-Spam-Level: 
X-Archive-Number: 200401/27
X-Sequence-Number: 16420

This is a multi-part message in MIME format.

------=_NextPart_000_0128_01C3D3A9.CFD6CB00
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Dear Friends,

I am working with Postgres 7.3.4 on RH Linux. Here is a need while developi=
ng an Calendar application.

I have a scheduled meeting at every month. While opening the calendar next =
2 month, I need to populate the records for it.

I dont want to use a temporary table and populate the records, as this will=
 slow down the function. Is there any method for that

Please shed some light.

Regards
Kumar

------=_NextPart_000_0128_01C3D3A9.CFD6CB00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"COLOR: #0000ff; FONT-FAMILY: Arial" bgColor=3D#ffffff>
<DIV><FONT size=3D2>Dear Friends,</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I am working with Postgres 7.3.4 on RH Linux. Here is a=
 need=20
while developing an Calendar application.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I have a scheduled meeting at every month. While openin=
g the=20
calendar next 2 month, I need to populate the records for it.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>I dont want to use a temporary table and populate the r=
ecords,=20
as this will slow down the function. Is there any method for that</FONT></D=
IV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Please shed some light.</FONT></DIV>
<DIV><FONT size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2>Regards</FONT></DIV>
<DIV><FONT size=3D2>Kumar</FONT></DIV>
<P></P></BODY></HTML>

------=_NextPart_000_0128_01C3D3A9.CFD6CB00--




From rhall@micropat.com Mon Jan  5 23:21:50 2004
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 68AE7D1B44D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  5 Jan 2004 23:21: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 89652-07
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon,  5 Jan 2004 19:21:02 -0400 (AST)
Received: from mail02.micropat.com (mail02.micropat.com [204.17.221.133])
	by svr1.postgresql.org (Postfix) with ESMTP id 8CFFED1B456
	for <pgsql-sql@postgresql.org>; Mon,  5 Jan 2004 19:21:00 -0400 (AST)
Received: from micropat.com ([204.17.221.91])
	by mail02.micropat.com (Lotus Domino Release 6.0.3)
	with ESMTP id 2004010518201451-7442 ; Mon, 5 Jan 2004 18:20:14 -0500
Message-ID: <3FF9F197.80707@micropat.com>
Date: Mon, 05 Jan 2004 18:21:59 -0500
From: Rich Hall <rhall@micropat.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.5) Gecko/20031007
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: psql <pgsql-sql@postgresql.org>
Subject: Re: Virtual records
References: <012b01c3d37b$b95c54e0$7502a8c0@hdsc.com>
In-Reply-To: <012b01c3d37b$b95c54e0$7502a8c0@hdsc.com>
X-MIMETrack: Itemize by SMTP Server on mail02/servers/mpat(Release
	6.0.3|September 18, 2003) at 01/05/2004 18:20:14,
	Serialize by Router on mail02/servers/mpat(Release 6.0.3|September 18,
	2003) at 01/05/2004 18:20:31,
	Serialize complete at 01/05/2004 18:20:31
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/30
X-Sequence-Number: 16423

How about a stored procedure that generates the set of records 
programatically.

Rick

Kumar wrote:

> Dear Friends,
>  
> I am working with Postgres 7.3.4 on RH Linux. Here is a need while 
> developing an Calendar application.
>  
> I have a scheduled meeting at every month. While opening the calendar 
> next 2 month, I need to populate the records for it.
>  
> I dont want to use a temporary table and populate the records, as this 
> will slow down the function. Is there any method for that
>  
> Please shed some light.
>  
> Regards
> Kumar