Changes between Version 10 and Version 11 of Noeud - parcours RHT

Timestamp:

Jan 4, 2012 4:32:05 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -54 +54 @@
 alter table rht.rhtvs2 add column noeudmer boolean default FALSE;
 update rht.rhtvs2 set noeudmer=TRUE where id_drain in (select id_drain from rht.noeudmervs2); --1082 noeudmer
+}}}
+
+== Nextdownid ==
+{{{
+#!sql
+create table rht.fromnodetonodevs2 as (select taval.id_drain as id_drainaval, tamont.id_drain as id_drainamont from rht.rhtvs2 tamont join rht.rhtvs2 taval on tamont.tnode=taval.fnode);
+alter table rht.rhtvs2 add column nextdownid integer;
+update rht.rhtvs2 SET nextdownid=id_drainaval from rht.fromnodetonodevs2 ft where id_drain=ft.id_drainamont;
+
+
+-- correction d'un problème par Cédric
+select  * from rht.rhtvs2 where id_drain=nextdownid
+update rht.rhtvs2 set nextdownid=-9999 where id_drain=nextdownid --505
 }}}