DBD::Pg ... how would I format this prepare?

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: DBD::Pg ... how would I format this prepare?
Date: 2006-07-26 21:29:32
Message-ID: 20060726182806.A1188@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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?

Thx

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . scrappy(at)hub(dot)org MSN . scrappy(at)hub(dot)org
Yahoo . yscrappy Skype: hub.org ICQ . 7615664

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2006-07-26 21:57:48 Re: DBD::Pg ... how would I format this prepare?
Previous Message Bruno Wolff III 2006-07-26 20:39:54 Re: Storing an ordered list