org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying XXX

最新推荐文章于 2025-01-06 02:18:13 发布

Huathy-雨落江南，浮生若梦

最新推荐文章于 2025-01-06 02:18:13 发布

阅读量5.4k

点赞数

分类专栏：数据库文章标签： postgresql 数据库 java

本文为博主Huathy原创文章，遵循 CC 4.0 BY-NC-SA 版权协议。
未经许可不得转载！否则将依法追究相关责任。

本文链接：https://blog.csdn.net/qq_40366738/article/details/119929411

版权

数据库专栏收录该内容

22 篇文章

订阅专栏

Pg数据库SQL错误：
错误原因：是由于SQL编写错误导致，或由于传参错误导致！
数据库错误信息

[42883] ERROR: operator does not exist: character varying = record 
建议：No operator matches the given name and argument types. You might need to add explicit type casts. 
位置：1063

错误示例：

select * from d_allotmoveai_setarea a where a.bills_id = ('123','456')

正确示例：

select * from d_allotmoveai_setarea a where a.bills_id = ('456')
select * from d_allotmoveai_setarea a where a.bills_id in ('123','456')

错误详细信息：
org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying <> record 建议：No operator matches the given name and argument types. You might need to add explicit type casts. 位置：323 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2578) ~[postgresql-42.2.11.jar:42.2.11] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2313) ~[postgresql-42.2.11.jar:42.2.11] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331) ~[postgresql-42.2.11.jar:42.2.11] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) ~[postgresql-42.2.11.jar:42.2.11] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) ~[postgresql-42.2.11.jar:42.2.11] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:159) ~[postgresql-42.2.11.jar:42.2.11] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:109) ~[postgresql-42.2.11.jar:42.2.11] at com.p6spy.engine.wrapper.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:78) ~[p6spy-3.9.1.jar:na] at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-3.4.2.jar:na] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar:na]