mybatis + postgresql

<select id="getTdLYbyPoint"   resultMap="TLBaseMap">
    select t.* from tdly t where st_DWithin(st_makepoint(#{ipx,jdbcType=DOUBLE} ,#{ipy,jdbcType=DOUBLE} ),t.geom,0)=true ;

</select>


报错:

 ### Error querying database.  Cause: org.postgresql.util.PSQLException: 错误: 函数 st_makepoint(character varying, character varying) 不存在
  建议:没有匹配指定名称和参数类型的函数. 您也许需要增加明确的类型转换.
  位置:41

转载自:https://blog.csdn.net/u012235264/article/details/64442600

You may also like...