ST_LineStringAggr( ST_Point ) method

Syntax

ST_LineString::ST_LineStringAggr( ST_Point point)

Parameters

• point – The points to generate the linestring. Typically this is a column.

Returns

ST_LineString Returns a linestring built from the points in a group.

Examples

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

  BEGIN
  DECLARE LOCAL TEMPORARY TABLE t_points( pk INT PRIMARY KEY,
  p ST_Point );
  INSERT INTO t_points VALUES( 1, 'Point( 0 0 )' );
  INSERT INTO t_points VALUES( 2, 'Point( 2 0 )' );
  INSERT INTO t_points VALUES( 3, 'Point( 1 1 )' );SELECT ST_LineString::ST_LineStringAggr( p ORDER BY pk )
  FROM t_points;
  END

Standards

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