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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: DBD::Pg ... how would I format this prepare?
Date: 2006-07-26 21:57:48
Message-ID: 18726.1153951068@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Marc G. Fournier" <scrappy(at)postgresql(dot)org> writes:
> 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?

NOW() + n * '1 day'::interval

n can be any numeric value ...

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jim Buttafuoco 2006-07-26 22:09:48 Re: DBD::Pg ... how would I format this prepare?
Previous Message Marc G. Fournier 2006-07-26 21:29:32 DBD::Pg ... how would I format this prepare?