pg数据库提示parse error at position 2 within geometry

xiaoxiao2025-07-19  9

pg数据库提示parse error at position 2 within geometry解决方法:

之前写的sql语句如下,但是一直报错:

UPDATE substation2 set geom=st_geomfromtext(concat(E'\'','POINT(',jd,' ',wd,')',E'\''),'4326')

经过修改成: 

UPDATE substation2 set geom=st_geomfromtext('POINT('|| jd ||' '|| wd ||')','4326')

成功!

转载请注明原文地址: https://www.6miu.com/read-5033337.html

最新回复(0)