ST_ForceSFS-ApsaraDB RDS(RDS)-阿里云帮助中心

Converts a geometry object to a geometry type defined in Simple Features for SQL (SFS) 1.1.

Syntax

geometry ST_ForceSFS(geometry geomA);
geometry ST_ForceSFS(geometry geomA, text version);

Parameters

Parameter	Description
geomA	The input geometry object.
version	The target SFS version.

Description

ST_ForceSFS supports the following geometry types:

Circular strings
Curves
Polyhedral surfaces
Triangles
Triangulated irregular network (TIN) surfaces
3D objects

Examples

SELECT ST_ForceSFS(ST_GeomFromText('POLYGON((1 1,2 1,2 2,1 2,1 1))'));
                          st_forcesfs
---------------------------------------------------------------
 01030000000100000005000000000000000000F03F000000000000F03F000.
.0000000000040000000000000F03F00000000000000400000000000000040.
.000000000000F03F0000000000000040000000000000F03F000000000000F.
.03F
(1 row)