ST_MultiCurve(ST_Curve,...) constructor

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

Syntax

NEW ST_MultiCurve(curve1,[curve2,...,curveN])

Parameters

Name	Type	Description
curve1	ST_Curve	The first curve value of the multi-curve.
curve2,...,curveN	ST_Curve	Additional curve values of the multi-curve.

Remarks

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

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

Note

By default, ST_MultiCurve 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 example returns the result MultiCurve ((0 0, 1 1)).

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

The following example returns the result MultiCurve ((0 0, 1 1), CircularString (0 0, 1 1, 2 0)).

SELECT NEW ST_MultiCurve( 
    NEW ST_LineString('LineString (0 0, 1 1)' ), 
    NEW ST_CircularString( 'CircularString( 0 0, 1 1, 2 0)' ) )

Discuss this page in DocCommentXchange.