Constructs a linestring value from a list of points in a specified spatial reference system.
NEW ST_LineString(pt1,pt2,[pt3,...,ptN])
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.
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.
SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension
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) ) |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |