Returns the ST_LineString interpolation of an ST_Curve value.
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