my $sql = " LOCK TABLE tabreserves IN SHARE MODE; SELECT tabreserves.date, tabreserves.hour_i, tabreserves.hour_e, tabreserves.idreserve, tabreserves.fk_idfield, tabfields.imped, tabfields.design FROM tabreserves LEFT JOIN tabfields ON tabfields.idfield = tabreserves.fk_idfield WHERE date = ? AND (hour_i < ? AND hour_e > ?) AND (fk_idfield = ? OR ? = ANY (imped)) LIMIT 1 "; #### DBD::Pg::st execute failed: ERROR: cannot insert multiple commands into a prepared statement #### DBD::Pg::st execute failed: ERROR: column "hour_i" is of type integer but expression is of type character varying HINT: You will need to rewrite or cast the expression.