Postgres Pro
Downloads
Home   >   mailing lists

Re: DBD::Pg ... how would I format this prepare? - Mailing list pgsql-sql

From Tom Lane
Subject Re: DBD::Pg ... how would I format this prepare?
Date
Msg-id 18726.1153951068@sss.pgh.pa.us
Whole thread Raw
In response to DBD::Pg ... how would I format this prepare?  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-sql
Tree view 
"Marc G. Fournier" <scrappy@postgresql.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

pgsql-sql by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: DBD::Pg ... how would I format this prepare?
Next
From: "Jim Buttafuoco"
Date:
Subject: Re: DBD::Pg ... how would I format this prepare?