ST_LineString( ST_Point , ST_Point , ST_Point ) constructor

Syntax

NEW ST_LineString( ST_Point pt1, ST_Point pt2, ST_Point pti)

Parameters

• pt1 – The first point of the linestring.
• pt2 – The second point of the linestring.
• pti – Additional points of the linestring.

Returns

ST_LineString Returns a linestring constructed from the specified points.

Examples

• Example 1 – 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) )

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension