pgsql获取point类型的经纬度

SELECT st_x(cast(point(100, 200) as geometry))

SELECT st_y(cast(point(100, 200) as geometry))

搜索

复制