org.postgresql.util.PSQLException: 错误: 操作符不存在: bigint = character varying
查看xml文件
提示类型不匹配,查看字段类型与对象属性是匹配的,出现此错误;
解决:标红处问题解决
DELETE FROM user_rel_tenant WHERE id
IN
<foreach collection="ids" item="it" open="(" close=")" separator=",">
#{it}::bigint
</foreach>