Changes between Version 6 and Version 7 of UsersWikiLinearRefFunctions
- Timestamp:
- 08/05/20 14:46:04 (4 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UsersWikiLinearRefFunctions
v6 v7 38 38 **Example 1: show the segment record returned** 39 39 40 * Note how the ST_LineLocateSegment function in the JOIN can reference the preceding table in the join41 (functions cause an implicit LATERAL join).42 40 43 41 {{{ … … 47 45 48 46 **Example 2: Add the closest point to the line** 47 48 * Note that the ST_LineLocateSegment function in the JOIN can reference the preceding table in the join 49 (functions cause an implicit LATERAL join). 50 49 51 {{{ 50 52 WITH data(id, line) AS (VALUES