Hibernate,PostgreSQL:如何在数组列中搜索

你可以这样注册daillect

public class MyPostgresSQLDialect extends PostgreSQLDialect {
  public MyPostgresSQLDialect() {
    super();

    this.registerFunction( "array_any", new SQLFunctionTemplate(StandardBasicTypes.INTEGER,"ANY(?1)") );
    this.registerFunction( "array_array", new SQLFunctionTemplate(StandardBasicTypes.INTEGER,"array[?1]") );

  }
}

String hql = " from tablename" +
            " where year = :year and month = :month and :version = array_any(versions)";

记住在sessionFactory中注册daillect

<prop key="hibernate.dialect">com.test.MyPostgresSQLDialect</prop>

这不是一个好的解决方案:

编写hql查询 select agents from Agents as agents where '11111' in (agents.zip_codes) 使用Hibernate拦截器

public class CustomInterceptor extends EmptyInterceptor {

  @Override
  public String onPrepareStatement(String sql) {
    return sql.replaceAll("\\s+in\\s*\\(", " = any (");
  }
}