<select id="getTdLYbyPoint" resultMap="TLBaseMap"> select t.* from tdly t where st_DWithin(st_makepoint(#{ipx,jdbcType=DOUBLE} ,#{ipy,jdbcType=DOUBLE} ),t.geom,0)
mybatis + postgresql
最新推荐文章于 2023-05-25 09:59:37 发布
<select id="getTdLYbyPoint" resultMap="TLBaseMap"> select t.* from tdly t where st_DWithin(st_makepoint(#{ipx,jdbcType=DOUBLE} ,#{ipy,jdbcType=DOUBLE} ),t.geom,0)