ST_MultiSurface( ST_MultiCurve , VARCHAR(128)) constructor

Syntax

NEW ST_MultiSurface( ST_MultiCurve multi_curve, VARCHAR(128) polygon_format)

Parameters

• multi_curve – A multicurve value containing exterior rings and (optionally) a set of interior rings.
• polygon_format – A string with the polygon format to use when interpreting the provided curves. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Returns

ST_MultiSurface Returns a multi-surface from the specified multilinestring.

Examples

• Example 1 – 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))'))

Standards

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