ST_CurveToLine() method

Returns the ST_LineString interpolation of an ST_Curve value.

Syntax

curve-expression.ST_CurveToLine()

ST_LineString Returns the ST_LineString interpolation of curve-expression.

Example 1 – The following example returns the result LineString (0 7, 0 4, 4 4) (a copy of the original linestring).
```
SELECT TREAT( Shape AS ST_Curve ).ST_CurveToLine()
FROM SpatialShapes WHERE ShapeID = 5
```
The following example returns the result LineString (0 0, 5 10) (the compound curve converted to an equivalent linestring).
```
SELECT NEW ST_CompoundCurve( 'CompoundCurve((0 0, 5 10))' ).ST_CurveToLine()
```
The following returns an interpolated linestring which approximates the original circularstring.
```
SELECT TREAT( Shape AS ST_Curve ).ST_CurveToLine()
FROM SpatialShapes WHERE ShapeID = 19
```

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