Returns the interpolation of the curve polygon as a polygon.
SELECT TREAT( Shape AS ST_Polygon ).ST_CurvePolyToPoly() FROM SpatialShapes WHERE ShapeID = 16
The following example returns the result Polygon ((0 0, 5 0, 5 10, 0 0))(the curve polygon converted to an equivalent polygon).
SELECT NEW ST_CurvePolygon( 'CurvePolygon(CompoundCurve((0 0, 5 10, 5 0, 0 0)))' ) .ST_CurvePolyToPoly()
The following returns an interpolated polygon which approximates the original curve polygon.
SELECT TREAT( Shape AS ST_CurvePolygon ).ST_CurvePolyToPoly() FROM SpatialShapes WHERE ShapeId = 24
SQL/MM (ISO/IEC 13249-3: 2006) 8.2.7