Changes between Version 3 and Version 4 of parcours RHT

Timestamp:

Oct 24, 2011 10:01:55 PM (14 years ago)

Author:

cedric

Comment:

--

parcours RHT

@@ -14 +14 @@
         distance bigint);
 copy rht.temp_ltree_distance from 'E:/workspace/EDAdata/dataEDArht/rht_ltree_distance.csv' with csv header delimiter as ';' NULL AS 'NA';--114600
+
+-- lancer le script ltree.sql qui se trouve dans postgres/share
+alter table rht.rht_topology add column chemin ltree;
+update rht.rht_topology t set chemin=sub.chemin from (
+select text2ltree(ltreetext) as chemin,id_drain from rht.temp_ltree_distance) as sub
+where t.id_drain=sub.id_drain;
 }}}