ST_IsSimple
ST_IsSimple returns true if the 2D projection of the input geometry is simple. For more information about the definition of a simple geometry, see Geometric simplicity.
Syntax
ST_IsSimple(geom)
Arguments
- geom
-
A value of data type
GEOMETRYor an expression that evaluates to aGEOMETRYtype.
Return type
BOOLEAN
If geom is null, then null is returned.
Examples
The following SQL checks if the specified linestring is simple. In this example, it isn't simple because it has self-intersection.
SELECT ST_IsSimple(ST_GeomFromText('LINESTRING(0 0,10 0,5 5,5 -5)'));
st_issimple
-----------
false
