ST_ToMultiSurface() method

Syntax

geometry-expression.ST_ToMultiSurface()

Returns

ST_MultiSurface If the geometry-expression is of type ST_MultiSurface, returns the geometry-expression. If the geometry-expression is a geometry collection containing only surfaces, returns a multi-surface object containing the elements of the geometry-expression. If the geometry-expression is of type ST_Surface then return a multi-surface value containing one element, the geometry-expression. If the geometry-expression is the empty set, returns an empty set of type ST_MultiSurface. Otherwise, raises an exception condition.

Examples

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

  SELECT NEW ST_GeomCollection().ST_ToMultiSurface()

  The following example returns the result MultiSurface (((3 3, 8 3, 4 8, 3 3))).

  SELECT Shape.ST_ToMultiSurface()
  FROM SpatialShapes WHERE ShapeID = 22

Standards

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