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

Example24.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)