X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 0D4CB475F16
	for <pgsql-sql@postgresql.org>; Thu,  1 May 2003 05:37:32 -0400 (EDT)
Received: from station1.osa.org (rdu57-84-123.nc.rr.com [66.57.84.123])
	by postgresql.org (Postfix) with ESMTP id 45375475E9D
	for <pgsql-sql@postgresql.org>; Thu,  1 May 2003 05:37:28 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by station1.osa.org (Postfix on SuSE Linux 8.1 (i686)) with ESMTP id
	C20DDA77
	for <pgsql-sql@postgresql.org>; Thu,  1 May 2003 05:38:41 -0400 (EDT)
From: Stuart <sfbarbee@yahoo.com>
Reply-To: sfbarbee@yahoo.com
To: pgsql-sql@postgresql.org
Subject: Re: Date Problem
Date: Thu, 1 May 2003 05:38:40 -0400
User-Agent: KMail/1.5.1
References: <3EB10DEB.1267.564751@localhost>
In-Reply-To: <3EB10DEB.1267.564751@localhost>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200305010538.41212.sfbarbee@yahoo.com>
X-Spam-Status: No, hits=-31.2 required=5.0
	tests=BAYES_30,EMAIL_ATTRIBUTION,FORGED_YAHOO_RCVD,IN_REP_TO,
	QUOTED_EMAIL_TEXT,REFERENCES,REPLY_WITH_QUOTES, USER_AGENT_KMAIL
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/4
X-Sequence-Number: 13169

Ramesh,

	If your field is a date field, you should be able to just do (From + 1), 
(From +2)....

	I know this works in 7.3.2 as in my example.. where published is a date field

select published,( published + 1), (published +2) from documents limit 10;                                     
 published  |  ?column?  |  ?column?  
------------+------------+------------
 2002-02-21 | 2002-02-22 | 2002-02-23
 2002-02-26 | 2002-02-27 | 2002-02-28
 2002-02-26 | 2002-02-27 | 2002-02-28
 2002-02-25 | 2002-02-26 | 2002-02-27
 

Hope this helps.

Stuart



On Thursday 01 May 2003 02:36, Ramesh PAtel wrote:
> Hi All
>
> now Problem is
>
> I have to date  From = '2003-04-01' and To='2003-05-12'
> now i want to use  use date butween  From and To.
> and each date one bye one use in query. so how to
>
> i  increse date one bye one
>
> Please Help me.
>
> Ramesh Patel
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

-- 
"... the Zionist state of Israel has ignored many United Nations Security 
Council Resolutions; possesses nuclear weapons and other weapons of mass 
destruction; is currently engaged in a genocidal programme of mass killings 
of Palestinians and that no attempt has been made by the United States or 
Britain to disarm Israel or to stop its genocidal mass killings of 
Palestinians" -- Result of Pan African Forum on Africans and the American 
Imperialist War February 23, 2003