ST_Polygon( ST_LineString , ST_LineString ) constructor

Syntax

NEW ST_Polygon( ST_LineString exterior_ring, ST_LineString interior_ringi)

Parameters

• exterior_ring – The exterior ring of the polygon
• interior_ringi – Interior rings of the polygon

Returns

ST_Polygon Returns a polygon created from the specified rings.

Examples

• Example 1 – 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_LineString ('LineString (-5 -1, 5 -1, 0 9, -5 -1)'),
  NEW ST_LineString ('LineString (-2 0, 0 4, 2 0, -2 0)'))

Standards

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