ST_Polygon(ST_MultiLineString[, VARCHAR(128)]) constructor

NEW ST_Polygon(multi-linestring[, polygon-format])

Name	Type	Description
multi-linestring	ST_MultiLineString	A multilinestring value containing an exterior ring and (optionally) a set of interior rings.
polygon-format	VARCHAR(128)	A string with the polygon format to use when interpreting the provided linestrings. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Creates a polygon from a multilinestring containing an exterior ring and an optional list of interior rings. The multilinestring must contain only linear rings.

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_Polygon 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.

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

The following returns Polygon ((-5 -1, 5 -1, 0 9, -5 -1), (-2 0, 0 4, 2 0, -2 0)) (a triangle with a triangular hole).

SELECT NEW ST_Polygon(
    NEW ST_MultiLineString ('MultiLineString ((-5 -1, 5 -1, 0 9, -5 -1), (-2 0, 0 4, 2 0, -2 0))'))

ST_Polygon(ST_MultiLineString[, VARCHAR(128)]) constructor

Syntax

Parameters

Remarks

Note

Standards and compatibility

Example