ST_ToMultiPoint() method

Converts the geometry to a multi-point value.

Syntax

geometry-expression.ST_ToMultiPoint()

Returns

ST_MultiPoint If the geometry-expression is of type ST_MultiPoint, returns the geometry-expression. If the geometry-expression is a geometry collection containing only points, returns a multipoint object containing the elements of the geometry-expression. If the geometry-expression is of type ST_Point then return a multi-point value containing one element, the geometry-expression. If the geometry-expression is the empty set, returns an empty set of type ST_MultiPoint. Otherwise, raises an exception condition.

Examples

Standards

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