ST_MultiPolygon(LONG BINARY[, INT]) constructor

Constructs a multi polygon from Well Known Binary (WKB).

Syntax

NEW ST_MultiPolygon(LONG BINARY wkb[, INT srid])

Parameters

wkb – A string containing the binary representation of a multi polygon. The input can be in any supported binary input format, including Well Known Binary (WKB) or Extended Well Known Binary (EWKB).
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 (((10 -5, 15 5, 5 5, 10 -5))).

SELECT NEW ST_MultiPolygon(0x01060000000100000001030000000100000004000000000000000000244000000000000014c00000000000002e40000000000000144000000000000014400000000000001440000000000000244000000000000014c0)

Standards

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