geometry_column –
The geometry values to generate the collection. Typically this is a column.
Returns
ST_MultiCurve Returns a multicurve that contains all of the geometries in a group.
Examples
Example 1 –
The following example returns a single value which combines all geometries of type ST_Curve from the SpatialShapes table into a single collection of type ST_MultiCurve. If the Shape column was of type ST_Curve then the TREAT function and WHERE clause would not be necessary.
SELECT ST_MultiCurve::ST_MultiCurveAggr( TREAT( Shape AS ST_Curve ) )
FROM SpatialShapes WHERE Shape IS OF( ST_Curve )