Changes between Version 40 and Version 41 of CCM2 download and load

Timestamp:

Apr 2, 2010 11:54:30 PM (15 years ago)

Author:

cedric

Comment:

--

CCM2 download and load

@@ -217 +217 @@
 SELECT ccm21.pricatch_from_catch(234706);
 }}}
+Franchement c'est pas gagné, je pense qu'il va falloir écrire les résulats intermédiaires dans des tables crées à cet effet
+{{{
+DROP  FUNCTION IF EXISTS ccm21.pricatch_from_catch(gid_ numeric);
+CREATE OR REPLACE FUNCTION ccm21.pricatch_from_catch(gid_ numeric) RETURNS void AS $$
+DECLARE
+result RECORD;
+BEGIN
+    SELECT INTO result strahler FROM ccm21.riversegments where gid=gid_;
+    RAISE NOTICE 'result is %' ,result;
+END;
+$$
+LANGUAGE 'plpgsql' ;
+SELECT ccm21.pricatch_from_catch(234706);
+-- message NOTICE:  result is (6)
+}}}