Changes between Version 45 and Version 46 of RHT PATE

Timestamp:

Apr 6, 2012 4:01:22 PM (13 years ago)

Author:

cedric

Comment:

--

RHT PATE

@@ -91 +91 @@
 select rht.sea_riversegment(20211);    
 }}}
+== fonction sql qui donne l'id_drain_mer sur le rht ==
+{{{
+#!sql
+select * from rht.rhtvs2 where noeudmer=TRUE --1082
+alter table rht.rhtvs2 add column id_drainmer integer;
+
+DROP TYPE IF EXISTS iddrainmer;
+CREATE TYPE iddrainmer as (iddrainmer int);
+
+CREATE OR REPLACE FUNCTION rht.setdownstreamsegment()
+  RETURNS integer AS
+$BODY$
+        DECLARE
+        numberiddrain integer;
+        iddrainmer iddrainmer%ROWTYPE;
+        BEGIN
+        numberiddrain=0;        
+        for iddrainmer in select id_drain from rht.rhtvs2 where noeudmer=TRUE loop
+                numberiddrain=numberiddrain+1;
+                update rht.rhtvs2 set id_drainmer=iddrainmer.iddrainmer where id_drain in (select rht.troncons_amont(iddrainmer.iddrainmer));
+                end loop;
+                return numberiddrain;   
+        END;
+$BODY$
+  LANGUAGE plpgsql ;
+
+
+select rht.setdownstreamsegment();
+
+}}}
+
 {{{
 #!sql