ST_MultiPoint(ST_Point,...) constructor

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

Syntax

NEW ST_MultiPoint(point1[,point2,...,pointN])

Parameters

Name	Type	Description
point1	ST_Point	The first point value of the multi-point.
point2,...,pointN	ST_Point	Additional point values of the multi-point.

Remarks

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

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

Note

By default, ST_MultiPoint 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 multi-point containing the single point 'Point (1 2)'.

SELECT NEW ST_MultiPoint( NEW ST_Point( 1.0, 2.0 ) )

The following returns a multi-point containing two points 'Point (1 2)' and 'Point (3 4)'.

SELECT NEW ST_MultiPoint( NEW ST_Point( 1.0, 2.0 ), NEW ST_Point( 3.0, 4.0 ) )

Discuss this page in DocCommentXchange.