Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198.
Existing Python UDFs will continue to function until June 30, 2026. For more information, see the
blog post
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
