ST_Polygon(LONG BINARY[, INT]) constructor

Constructs a polygon from Well Known Binary (WKB).

Syntax

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

Parameters

wkb – A string containing the binary representation of a 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_Polygon Returns an ST_Polygon value constructed from the source string.

Examples

Example 1 – The following returns Polygon ((10 -5, 15 5, 5 5, 10 -5)).

SELECT NEW ST_Polygon(0x01030000000100000004000000000000000000244000000000000014c00000000000002e40000000000000144000000000000014400000000000001440000000000000244000000000000014c0)

Standards

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