Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 19E809FC132 for ; Wed, 8 Aug 2007 12:16:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 88371-01 for ; Wed, 8 Aug 2007 12:16:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.mediamatters.org (mail.mediamatters.org [63.240.197.71]) by postgresql.org (Postfix) with ESMTP id 273AD9FC0CB for ; Wed, 8 Aug 2007 12:16:34 -0300 (ADT) Received: from [10.1.0.133] (63-146-242-133.dia.static.qwest.net [63.146.242.133]) by mail.mediamatters.org (Postfix) with ESMTP id 86A5196C18C; Wed, 8 Aug 2007 11:16:06 -0400 (EDT) Message-ID: <46B9DE39.2030608@mediamatters.org> Date: Wed, 08 Aug 2007 11:16:09 -0400 From: Jon Sime Organization: Media Matters for America User-Agent: Thunderbird 2.0.0.6 (X11/20070806) MIME-Version: 1.0 To: "Abraham, Danny" Cc: PostgreSQL Admin Subject: Re: How do I do a dynamic - select now() + interval X days ? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/72 X-Sequence-Number: 26403 Abraham, Danny wrote: > Thanks For doing that based on an arbitrary value, just do the following: select now() + interval '1 day' * X; -Jon -- Senior Systems Developer Media Matters for America http://mediamatters.org/