select * from netbardistrict_dimension where district_key like '%0';ERROR: operator does not exist: integer ~~ unknown
LINE 1: ...* from netbardistrict_dimension where district_key like '%0'
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.********** 错误 **********ERROR: operator does not exist: integer ~~ unknown
SQL 状态: 42883
指导建议:No operator matches the given name and argument type(s). You might need to add explicit type casts.
字符:59
district_key是INT型 但是我 如何把字符型转化为INT呢? 这个数据库语句 改怎么写?
文章出处:飞诺网(www.firnow.com):http://dev.firnow.com/course/7_databases/mysql/Mysqljs/20071120/87162.html
testdb=# select CAST(100 as varchar) like '%0';
?column?
----------
t
(1 row)testdb=#