ST_ToSurface() method

Syntax

geometry-expression.ST_ToSurface()

Returns

ST_Surface If the geometry-expression is of type ST_Surface, return the geometry-expression. If the geometry-expression is a geometry collection with a single element of type ST_Surface, return that element. If the geometry-expression is the empty set, return an empty set of type ST_Polygon. Otherwise, raise an exception condition.

Examples

• Example 1 – The following example returns the result Polygon EMPTY.

  SELECT NEW ST_GeomCollection().ST_ToSurface()

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension