我有一个与PDO和Postgres有关的问题:
当我尝试使用float
字段的CC_1值搜索时,我会遇到错误:
$stmt = $con->prepare('SELECT t.* FROM my_table t WHERE t.integer_field > ?');
$stmt->execute([9.5]);
这也行不通:
$stmt = $con->prepare('SELECT t.* FROM my_table t WHERE t.integer_field > ?');
$stmt->execute(['9.5']);
这也行不通:
$stmt = $con->prepare('SELECT t.* FROM my_table t WHERE t.integer_field > ?');
$param = 9.5;
$stmt->bindParam(1, $param, PDO::PARAM_INT);
$stmt->execute();
错误:Invalid text representation: 7 ERROR: invalid input syntax for integer: "9.5"
这是设计还是Postgres/PDO不兼容?
顺便说一句,当我在没有报价的情况下插入浮标时,它可以工作:
$stmt = $con->prepare('SELECT t.* FROM my_table t WHERE t.integer_field > 9.5');
$stmt->execute();
和Postgres不会输入INT,因为我在运行这些查询时会看到不同的记录:
$con->prepare('SELECT t.* FROM my_table t WHERE t.integer_field < 5.1');
$con->prepare('SELECT t.* FROM my_table t WHERE t.integer_field < 4.9');
#given that integer_field is 5
版本:PHP 7.2.19PostgreSQL 10.4
一段时间后,我弄清楚了工作查询:
$stmt = $con->prepare('SELECT t.* FROM my_table t WHERE CAST(t.integer_field AS FLOAT) > ?');
$stmt->execute([9.5]);
请,如果您有其他解决方案,请随时发布其他答案!