http://qs1969.pair.com?node_id=513943

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