ST_MultiLineString( ST_LineString , ST_LineString ) constructor

Syntax

NEW ST_MultiLineString( ST_LineString linestring1, ST_LineString linestringi)

Parameters

• linestring1 – The first linestring value of the multi-linestring.
• linestringi – Additional linestring values of the multi-linestring.

Returns

ST_MultiLineString A multi-linestring containing the provided linestring values.

Examples

• Example 1 – 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)' ) )

Standards

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