ST_PointFromText
Prev 2. Geometry Constructors Next

Name

ST_PointFromText — Constructs a MultiPoint object given its Well-known text Representation

Synopsis

geometry ST_PointFromText(varchar WKT);

geometry ST_PointFromText(varchar WKT, integer SRID);

Alias

PointFromText

Description

Constructs a MultiPoint object given its Well-known text Representation. If the SRID is not provided it defaults to -1.

Returns Null when the WKT is not a MultiPoint or MultiPointM.

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.6.27.2.6.1-6.1.8

Examples

--EWKT Representation of a 3D Point.
SELECT ST_Asewkt(ST_PointFromText('POINT(5 5 10)'));
--Result
MULTIPOINT (5 5 10)

--EWKT Representation of a 4D Point.
SELECT ST_Asewkt(ST_PointFromText('POINT(5 5 10 -20)',25830)) as mypoint;
--Result
MYPOINT  
SRID=25830;POINT (5 5 10 -20)

Related functions

ST_MPointFromTextST_GeomFromText

Prev Up Next
ST_Point Home ST_PointFromWKB