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