Changes between Version 5 and Version 6 of UsersWikiLinearRefFunctions

Timestamp:

Aug 5, 2020, 2:45:11 PM (4 years ago)

Author:

mdavis

Comment:

—

UsersWikiLinearRefFunctions

@@ -38 +38 @@
 **Example 1: show the segment record returned**
 
+* Note how the ST_LineLocateSegment function in the JOIN can reference the preceding table in the join
+(functions cause an implicit LATERAL join). 
+
 {{{
 SELECT ST_LineLocateSegment( 'LINESTRING (0 0, 10 10, 20 20, 30 30)'::geometry,
@@ -47 +50 @@
 WITH data(id, line) AS (VALUES
     ( 1, 'LINESTRING (0 0, 10 10, 20 20, 30 30)'::geometry )
-),
-loc AS (
-  SELECT id, line, index, geom AS pt
-    FROM data CROSS JOIN ST_LineLocateSegment( data.line, 'POINT(15 15.1)'::geometry ) 
 )
-SELECT id, ST_AsText( ST_AddPoint( line, pt, index ) ) FROM loc;
+SELECT id, ST_AddPoint( data.line, geom, index )
+  FROM data CROSS JOIN ST_LineLocateSegment( data.line, 'POINT(15 15.1)'::geometry );
 }}}