Changes between Version 21 and Version 22 of import layers postgis

Timestamp:

Jun 23, 2018 8:36:13 PM (7 years ago)

Author:

cedric

Comment:

--

import layers postgis

@@ -107 +107 @@
 $$
 BEGIN
-        RAISE NOTICE 'downstream segment for %', _id;    -- prints the selected segment
-        RETURN QUERY   
+        RAISE NOTICE 'downstream segment for %', _id;                                 -- prints the selected segment
+        RETURN QUERY                                                                  -- RETURN QUERY allows to return a table without loop
              SELECT r.pfafcuen, r.lngtramo_m from  oria_a_rios_v2 r 
                 WHERE
                  substring(_id::text,1,char_length(_id::text)-1)= 
-                   substring(r.pfafcuen::text,1,char_length(r.pfafcuen::text)-1) 
+                   substring(r.pfafcuen::text,1,char_length(r.pfafcuen::text)-1)     -- the selection is done on a subset eg. 10011 10013  10015  10017  will be selected using string 1001
                 AND
-                 _id>r.pfafcuen
+                 _id>r.pfafcuen                                                      -- we select only segments downstream from the current one
                 AND
-                 (r.pfafcuen::numeric % 2) = 1 
-               order by r.pfafcuen::numeric DESC;  -- even number               
+                 (r.pfafcuen::numeric % 2) = 1                                       -- even number     
+               order by r.pfafcuen::numeric DESC;       
 END
 $$