ST_MPointFromWKB
Prev 2. Geometry Constructors Next

Name

ST_MPointFromWKB — Returns a MultiPoint object given its Well-known binary Representation

Synopsis

geometry ST_MPointFromWKB(bytea WKB);

geometry ST_MPointFromWKB(bytea WKB, integer SRID);

Alias

MPointFromWKB

Description

Creates a MultiPoint from well-known binary representation of a Point and a Spatial Reference System ID (SRID). If the SRID is not provides it defaults to -1. If WKB passed in is not a MultiPoint, NULL is returned.

Coordinate Dimensions
2D3DM
Spatial Standards Support
OGC SFS for SQL. 1.1 (1999)OGC SFS for SQL. 1.1.0 (2005)OGC SFS for SQL. 1.2.0 (2006)SQL-MM Part 3
3.2.7.27.2.7.1-9.2.5

Examples

SELECT ST_AsEWKT(ST_MPointFromWKB(ST_GeomFromText('MULTIPOINT (0 0, 1 1, 2 2)')));
--Result
MULTIPOINT (0 0, 1 1, 2 2)

SELECT ST_AsEWKT(ST_MPointFromWKB(ST_GeomFromText('MULTIPOINT (0 0, 1 1, 2 2)'),25830));
--Result
SRID=25830;MULTIPOINT (0 0, 1 1, 2 2)

Related functions

ST_GeomFromWKB

Prev Up Next
ST_PolyFromWKB Home ST_MLineFromWKB