Changes between Version 17 and Version 18 of Noeud - parcours RHT

Timestamp:

Jan 4, 2012 5:03:43 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -79 +79 @@
 update rht.rhtvs2 set nextdownid=-9999 where noeudmer='t' --1082 lignes
 }}}
+
+== Noeud source ==
+{{{
+#!sql
+alter table rht.rhtvs2 add column noeudsource boolean default FALSE;
+-- identification des noeuds source
+update rht.rhtvs2 set noeudsource=TRUE where id_drain in (
+select id_drain from rht.rhtvs2 except (
+select rt2.id_drain from rht.rhtvs2 rt1 join rht.rhtvs2 rt2 on rt1.nextdownid=rt2.id_drain)
+);-- 57493 lignes
+}}}
+
 
 == Identification des différentes zones, manche, Bretagne, Méditerranée, Golfe de Gascogne, Est France, Pyrénnées ==