|P is for Practical|
OT: Postgres, now(), and bindvarsby Ryszard (Priest)
|on Dec 04, 2005 at 12:54 UTC||Need Help??|
Ryszard has asked for the
wisdom of the Perl Monks concerning the following question:
I'm having a bit of trouble with updating a date using bindvars.
Sounds simple i hear you say? Probably is, but i'll be buggered if i can find documentation on how. In a previous incantation of this problem i've done away with the bindvar and used a variable (shudder).
Basically i want something that looks like this: insert into table (ex_date) values (now()+"? minutes"::interval)
The unfortunate thing is postgres whinging with the error DBD::Pg::st execute failed: called with 3 bind variables when 2 are needed
Various permutations of the above syntax i also cant get to work, and so, here I am, on my quest for a bit of perl (and postgres) wisdom