ST_ExteriorRing( ST_Curve ) method

Syntax

polygon-expression.ST_ExteriorRing( ST_Curve curve)

Parameters

• curve – The new exterior ring of the polygon. This must be a linear ring value.

Returns

ST_Polygon Returns a copy of the polygon with specified exterior ring.

Examples

• Example 1 – The following example returns the result Polygon ((0 1, 10 1, 5 10, 0 1), (3 3, 3 5, 7 5, 7 3, 3 3)).

  SELECT NEW ST_Polygon('Polygon ((0 0, 10 0, 5 10, 0 0), (3 3, 3 5, 7 5, 7 3, 3 3))')
  .ST_ExteriorRing( NEW ST_LineString( 'LineString(0 1, 10 1, 5 10, 0 1)' ) )

Standards

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