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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: OT: Postgres, now(), and bindvars
by cees (Curate) on Dec 04, 2005 at 13:26 UTC | |
Re: OT: Postgres, now(), and bindvars
by EvanCarroll (Chaplain) on Dec 04, 2005 at 21:53 UTC | |
Re: OT: Postgres, now(), and bindvars
by Ryszard (Priest) on Dec 07, 2005 at 11:36 UTC |
Back to
Seekers of Perl Wisdom