On Wed, 23 Mar 2005 15:11:13 -0600 (CST), Brandon Metcalf <[EMAIL PROTECTED]> wrote: > I have several cases where if I try to prepare() a statement and then > execute() it, I get the following: > > DBD::Pg::st execute failed: ERROR: column "report_time" is of type integer > but expression is of type character varying > HINT: You will need to rewrite or cast the expression.
Well, I may regret saying this, but to me it sure sounds like a bug in your script :-( Do you by chance have ascii chars in your variable that Perpare is trying to set up (as an int)? Maybe a null value? Is the size of the variable value too large to fit in an int? Remember- Int's are pretty small - you might want to alter your schema to fit a long type. HTH, K.C
