ST_ExteriorRing Method | Geospatial Data Types | Teradata Vantage - ST_ExteriorRing - Advanced SQL Engine - Teradata Database

Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
ufo1590694251930.ditamap
dita:ditavalPath
ufo1590694251930.ditaval
dita:id
B035-1181
lifecycle
previous
Product Category
Teradata Vantage™

Get and set the exterior ring of an ST_Geometry type that represents an ST_Polygon value.

Valid Data Types

ST_Polygon

This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations. Consequently, any z coordinates returned by this method should be ignored. Teradata recommends using the Make_2D method to strip out the z coordinates of the return value.

Result Type

Returns an ST_Geometry value.

IF you … THEN ST_ExteriorRing returns …
do not pass in the acurve argument an ST_LineString of the exterior ring of the ST_Polygon.
pass in the acurve argument the new ST_Polygon with the exterior ring set to the value of the acurve argument.