X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B4D349FB337 for ; Mon, 31 Jul 2006 09:24:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82548-01 for ; Mon, 31 Jul 2006 09:24:39 -0300 (ADT) X-Greylist: delayed 00:26:54.933172 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 430DB9FB33E for ; Mon, 31 Jul 2006 09:23:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from plouf.absolight.net (plouf.absolight.net [193.30.224.136]) by svr4.postgresql.org (Postfix) with ESMTP id A04AA5AF037 for ; Mon, 31 Jul 2006 11:56:38 +0000 (GMT) Received: from andromede.in.absolight.net (andromede.in.absolight.net [193.30.224.82]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by plouf.absolight.net (Postfix) with ESMTP id A1367554002 for ; Mon, 31 Jul 2006 13:56:18 +0200 (CEST) Date: Mon, 31 Jul 2006 13:56:18 +0200 From: Mathieu Arnold To: pgsql-sql@postgresql.org Subject: Re: DBD::Pg ... how would I format this prepare? Message-ID: <9DC3746EE73F939BF99CC882@andromede.in.absolight.net> In-Reply-To: <20060726182806.A1188@ganymede.hub.org> References: <20060726182806.A1188@ganymede.hub.org> X-Mailer: Mulberry/4.0.4 (Win32) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.816 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200607/376 X-Sequence-Number: 25950 +-le 26/07/2006 18:29 -0300, Marc G. Fournier a dit : | | I need to do: | | NOW() + '2 day'::interval | | where 2 is a variable ... | | if I do: | | NOW() + '? day'::interval | | it, of course, takes the ? as a literal ... so is there some way I can do | this such that I can do the placeholder? I think that ! is what you're looking for. -- Mathieu Arnold