ST_MultiSurface(ST_MultiCurve[, VARCHAR(128)]) constructor

Creates a multi-surface from a multicurve containing exterior rings and an optional list of interior rings.

Syntax

NEW ST_MultiSurface(multi-curve[, polygon-format])

Parameters

Name	Type	Description
multi-curve	ST_MultiCurve	A multicurve value containing exterior rings and (optionally) a set of interior rings.
polygon-format	VARCHAR(128)	A string with the polygon format to use when interpreting the provided curves. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Remarks

Creates a multi-surface from a multicurve containing exterior rings and an optional list of interior rings. The multicurve may contain any curve type.

If specified, the polygon-format parameter selects the algorithm the server uses to determine whether a ring is an exterior or interior ring. If not specified, the polygon format of the spatial reference system is used.

For additional information on polygon-format, see POLYGON FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

Note

By default, ST_MultiSurface uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

Standards and compatibility

Example

The following returns MultiSurface (CurvePolygon ((-4 -4, 4 -4, 4 4, -4 4, -4 -4), (-2 1, -3 3, -1 3, -2 1)), CurvePolygon ((6 -4, 14 -4, 14 4, 6 4, 6 -4), CircularString (9 -1, 9 1, 11 1, 11 -1, 9 -1)))

SELECT NEW ST_MultiSurface(NEW ST_MultiCurve ('MultiCurve ((-4 -4, 4 -4, 4 4, -4 4, -4 -4), (-2 1, -3 3, -1 3, -2 1), (6 -4, 14 -4, 14 4, 6 4, 6 -4), CircularString (9 -1, 9 1, 11 1, 11 -1, 9 -1))'))

Discuss this page in DocCommentXchange.