Changes between Version 23 and Version 24 of import layers postgis

Timestamp:

Jun 23, 2018 8:43:58 PM (7 years ago)

Author:

cedric

Comment:

--

import layers postgis

@@ -133 +133 @@
 
 10037146451 => 1003714643
+{{{#!sql
+-- this query returns nothing
+with d1 as (SELECT    pfafcuen, 
+                  lngtramo_m, 
+                  (substring(pfafcuen::text,1,char_length(pfafcuen::text)-1)::integer-2)::character varying(254) 
+                  as pfafcuen_downstream 
+  from downstream_segments('10037146457'))
+select * from downstream_segments((select min(pfafcuen_downstream) FROM d1 limit 1));
+--because this query returns nothing
+select downstream_segments('1003714643');
+}}}
 
 Before trying too much the following problem arises [[BR]]