ST_LineString(ST_Point,ST_Point,...) constructor

Constructs a linestring value from a list of points in a specified spatial reference system.

Syntax

NEW ST_LineString(pt1,pt2,[pt3,...,ptN])

Parameters

Name	Type	Description
pt1	ST_Point	The first point of the linestring.
pt2	ST_Point	The second point of the linestring.
pt3,...,ptN	ST_Point	Additional points of the linestring.

Constructs a linestring value from a list of points. All of the points must have the same SRID. The resulting linestring is constructed with this common SRID. All of the supplied points must be non-empty and have the same answer for Is3D and IsMeasured. The linestring is 3D if all of the points are 3D, and the linestring is measured if all of the points are measured.

Note

By default, ST_LineString 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 LineString (0 0, 1 1).

SELECT NEW ST_LineString( NEW ST_Point( 0, 0 ), NEW ST_Point( 1, 1 ) )

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

SELECT NEW ST_LineString( NEW ST_Point( 0, 0 ), NEW ST_Point( 1, 1 ), NEW ST_Point(2,0) )