我有一个问题
SELECT assetid, type_code, version, name, short_name, status, languages,
charset, force_secure, created, created_userid, updated, updated_userid,
published, published_userid, status_changed, status_changed_userid
FROM sq_ast WHERE assetid = 7
这个不起作用并抛出异常
ERROR: operator does not exist: character varying = integer LINE 4: FROM sq_ast WHERE assetid = 7
我可以通过以下方式使其工作
SELECT assetid, type_code, version, name, short_name, status, languages,
charset, force_secure, created, created_userid, updated, updated_userid,
published, published_userid, status_changed, status_changed_userid
FROM sq_ast WHERE assetid = '7'
请注意在WHERE子句中引用数字7...
我正在部署一个庞大的应用程序,我无法重写核心代码......同样,我不想冒险更改列的类型......
我不是Postgres专家......请帮忙......
是否有严格强制转换列的选项?