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

From Mathieu Arnold
Subject Re: DBD::Pg ... how would I format this prepare?
Date
Msg-id 9DC3746EE73F939BF99CC882@andromede.in.absolight.net
Whole thread Raw
In response to DBD::Pg ... how would I format this prepare?  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-sql
+-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


pgsql-sql by date:

Previous
From: John DeSoi
Date:
Subject: Re: Triggers using PL/pgSQL
Next
From: "Aaron Bono"
Date:
Subject: Re: Triggers using PL/pgSQL