ST_MultiLineString(ST_LineString,...) constructor

Constructs a multi-linestring from a list of linestring values.

Syntax

NEW ST_MultiLineString(linestring1,[linestring2,...,linestringN])

Parameters

Name	Type	Description
linestring1	ST_LineString	The first linestring value of the multi-linestring.
linestring2,...,linestringN	ST_LineString	Additional linestring values of the multi-linestring.

Remarks

Constructs a multi-linestring from a list of linestring values. All of the supplied linestring values must have the same SRID, and the multi-linestring is constructed with this common SRID.

All of the supplied linestring values must have the same answer for Is3D and IsMeasured. The multi-linestring is 3D if all of the linestring values are 3D, and the multi-linestring is measured if all of the linestring values are measured.

Note

By default, ST_MultiLineString uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

Standards and compatibility

Example

The following returns a multilinestring containing a single linestring and is equivalent to the following WKT: 'MultiLineString ((0 0, 1 1))'

SELECT NEW ST_MultiLineString( NEW ST_LineString('LineString (0 0, 1 1)' ) )

The following returns a multilinestring containing two linestrings equivalent to the following WKT: 'MultiLineString ((0 0, 1 1), (0 0, 1 1, 2 0))'.

SELECT NEW ST_MultiLineString( 
        NEW ST_LineString('LineString (0 0, 1 1)' ), 
        NEW ST_LineString( 'LineString( 0 0, 1 1, 2 0)' ) )

Discuss this page in DocCommentXchange.