Changes between Version 27 and Version 28 of RHT PATE

Timestamp:

Jan 27, 2012 3:09:30 PM (13 years ago)

Author:

cedric

Comment:

--

RHT PATE

@@ -29 +29 @@
 DROP TYPE IF EXISTS id_drain;
 CREATE TYPE id_drain as (id_drain int);
+-- je sors le create table de la fonction pour gagner du temps... Attention à bien le lancer sinon ça plantera
+DROP TABLE IF EXISTS rht.upstream_riversegments;
+CREATE TABLE rht.upstream_riversegments(id_drain integer);
 DROP  FUNCTION IF EXISTS rht.upstream_segments(id_ numeric);
 CREATE OR REPLACE FUNCTION rht.upstream_segments(id_ numeric) RETURNS setof int AS $$
@@ -35 +38 @@
         BEGIN
         -- filling a new table with the results from a catchment
-        
-        DROP TABLE IF EXISTS rht.upstream_riversegments;
-        CREATE TABLE rht.upstream_riversegments(id_drain integer);
         EXECUTE 'insert into rht.upstream_riversegments (select cast(unnest(vecteurchemin) as integer) as id_drain 
         from (SELECT regexp_split_to_array(ltree2text(chemin),E''\\\\.+'') as vecteurchemin from rht.rhtvs2 where chemin ~ ''*.'||id_||'.*'') as sub