【异常】PGSQL提示 ERROR: operator does not exist: character varying = integer
作者:mmseoamin日期:2023-12-27

一、报错内容

Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
  建议:No operator matches the given name and argument types. You might need to add explicit type casts.
  位置:330
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)

二、报错说明

这是数据库和实体类里面字段类型不一致造成的报错&#