Changes between Version 4 and Version 5 of UsersWikiLinearRefFunctions

Timestamp:

Aug 5, 2020, 2:41:18 PM (4 years ago)

Author:

mdavis

Comment:

—

UsersWikiLinearRefFunctions

@@ -50 +50 @@
 loc AS (
   SELECT id, line, index, geom AS pt
-    FROM data
-    JOIN LATERAL ST_LineLocateSegment( data.line, 'POINT(15 15.1)'::geometry ) AS lls ON true
+    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_AsText( ST_AddPoint( line, pt, index ) ) FROM loc;
 }}}