ST_MultiLineStringAggr( ST_LineString ) method

Returns a multilinestring containing all of the linestrings in a group.

Syntax

ST_MultiLineString::ST_MultiLineStringAggr( ST_LineString geometry_column)

geometry_column – The geometry values to generate the collection. Typically this is a column.

ST_MultiLineString Returns a multilinestring that contains all of the geometries in a group.

Example 1 – The following example returns a single value which combines all geometries of type ST_LineString from the SpatialShapes table into a single collection of type ST_MultiLineString. If the Shape column was of type ST_LineString then the TREAT function and WHERE clause would not be necessary.
```
SELECT ST_MultiLineString::ST_MultiLineStringAggr( TREAT( Shape AS ST_LineString ) )
FROM SpatialShapes WHERE Shape IS OF( ST_LineString )
```

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