Name
st_linestring — returns a linestring in default SRID
Synopsis
st_linestring
(
|
in item1 any , |
| in item2 any , | |
in
itemN
any
); |
Description
returns a linestring in default SRID, the coordinates of vertices are specified by arguments that are points, 2-, 3- or 4-item vectors of coordinates, linestrings, arcstrings or vectors of the above mentioned values. Repeating vertices are automatically removed, except the case of repeating vertices in the middle of a linestring/arcstring argument.
Parameters
item1
Geometry.
item2
Geometry.
itemN
Geometry.
Return Types
Returns varchar.
Examples
Example 24.665. Simple Use
SQL> select st_linestring (st_point (11,22),
st_point (13, 24),
st_point (13,24),
st_point (15,26),
st_point (17,28))
unnamed
VARCHAR NOT NULL
_______________________________________________________________________________
LINESTRING(11.0 22.0,13.0 24.0,15.0 26.0,17.0 28.0)
SQL> select st_linestring (st_linestring (vector(vector (11,22),
vector (13, 24))),
st_linestring (vector (13,24), vector(vector (15,26),
vector (17,28))))
st_linestring
VARCHAR
_______________________________________________________________________________
LINESTRING(11.0 22.0,13.0 24.0,15.0 26.0,17.0 28.0)