st_castToLineString
LineString st_castToLineString(Geometry g)
将Geometry g转换为LineString。
示例:
- 查询命令:
select st_astext(st_castToLineString(st_geomFromWKT(location))) from geotbl where id='5'
- 查询结果:
LINESTRING (30 10, 40 40, 20 40, 10 20, 30 10)
st_castToPoint
Point st_castToPoint(Geometry g)
将Geometry g转换为Point。
示例:
st_castToPolygon
Polygon st_castToPolygon(Geometry g)
将Geometry g转换为Polygon。
示例:
- 查询命令:
select st_astext(st_castToPolygon(st_geomFromWKT(location))) from geotbl where id='1'
- 查询结果:
POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))
st_byteArray
Array[Byte] st_byteArray(String s)
使用UTF-8字符集将字符串s编码为字节数组。
示例: