ST_MultiPolygon(LONG VARCHAR[, INT]) constructor

Syntax

NEW ST_MultiPolygon(LONG VARCHAR text_representation[, INT srid])

Parameters

• text_representation – A string containing the text representation of a multi polygon. The input can be in any supported text input format, including Well Known Text (WKT) or Extended Well Known Text (EWKT).
• srid – The SRID of the result. If not specified, the default is 0.

Returns

ST_MultiPolygon Returns an ST_MultiPolygon value constructed from the source string.

Examples

• Example 1 – The following returns MultiPolygon (((-5 -5, 5 -5, 0 5, -5 -5), (-2 -2, -2 0, 2 0, 2 -2, -2 -2)), ((10 -5, 15 5, 5 5, 10 -5))).

  SELECT NEW ST_MultiPolygon('MultiPolygon (((-5 -5, 5 -5, 0 5, -5 -5), (-2 -2, -2 0, 2 0, 2 -2, -2 -2)), ((10 -5, 15 5, 5 5, 10 -5)))')

Standards

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