Changes between Version 27 and Version 28 of Noeud - parcours RHT

Timestamp:

Jan 5, 2012 1:25:43 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -113 +113 @@
 update rht.rhtvs2 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; --114600
+where t.id_drain=sub.id_drain; --114564 lines
 
 -- mise à jour des distances mer
-
+alter table rht.rhtvs2 add column dmer numeric;
 update rht.rhtvs2 t set dmer=sub.distance from (
 select distance,id_drain from rht.temp_ltree_distance) as sub
 where t.id_drain=sub.id_drain
-and dmer is null;  --113517
+and dmer is null;  --
 }}}