X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id EF1999DC815 for ; Wed, 28 Dec 2005 11:33:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90840-01 for ; Wed, 28 Dec 2005 11:33:10 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.200]) by postgresql.org (Postfix) with ESMTP id D862A9DC825 for ; Wed, 28 Dec 2005 11:33:03 -0400 (AST) Received: by xproxy.gmail.com with SMTP id s14so996357wxc for ; Wed, 28 Dec 2005 07:33:09 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=UqU+hZe0xxSGLVxH0b6zyO4ymE7uHr+0sVxAafiW1P3HzQsNiOGFe4spUKPR6m2FHyH0siwxdUUiNjAIWEEsMxu0+2bhXxTswboSwFwJ0WEOLy/tQ/ooauLtf/I73fPFZNl+GaDZGpgsjlFS3/mI+FEeDTCo9bGIUslKVUsKBqg= Received: by 10.70.7.19 with SMTP id 19mr7840051wxg; Wed, 28 Dec 2005 07:33:08 -0800 (PST) Received: by 10.70.84.7 with HTTP; Wed, 28 Dec 2005 07:33:08 -0800 (PST) Message-ID: <1d219a6f0512280733k74c7ecf6kdff6408ba6c6bfa5@mail.gmail.com> Date: Wed, 28 Dec 2005 10:33:08 -0500 From: Chris Hoover To: Jason Minion Subject: Re: Help with simple function Cc: pgsql-admin@postgresql.org In-Reply-To: <0105A1BF505D304E9E5AF38B63E40E4ED7E895@EXCHANGE.siglercompanies.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_46726_1743243.1135783988821" References: <0105A1BF505D304E9E5AF38B63E40E4ED7E895@EXCHANGE.siglercompanies.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.048 required=5 tests=[AWL=0.047, HTML_MESSAGE=0.001] X-Spam-Score: 0.048 X-Spam-Level: X-Archive-Number: 200512/344 X-Sequence-Number: 20064 ------=_Part_46726_1743243.1135783988821 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 12/28/05, Jason Minion wrote: > > And last but not least, you can do simple day addition and subtraction > with dates using integers. For example: > > > select '2005-12-26'::date + 8; > > returns '2006-01-03'. However, I'm not sure if that will work with > 7.3.x. Good luck with your 8.x install! > > Jason That works like a charm. Thanks a bunch for the help. Chris ------=_Part_46726_1743243.1135783988821 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 12/28/05, Jason Minion <jason.minion@sigler.com> wrote:
=
And last but not least, you can do simple day addition and subtraction
w= ith dates using integers. For example:

> select '2005-12-26'::dat= e + 8;

returns '2006-01-03'. However, I'm not sure if that will work= with
7.3.x. Good luck with your 8.x install!

Jason
<= br> That works like a charm.  Thanks a bunch for the help.

Chris


------=_Part_46726_1743243.1135783988821--