Changes between Version 47 and Version 48 of Noeud - parcours RHT

Timestamp:

Jan 8, 2012 10:54:56 PM (13 years ago)

Author:

celine

Comment:

--

Noeud - parcours RHT

@@ -170 +170 @@
 CREATE INDEX indexroev2_rhtvs2 ON rht.rhtvs2_roev2
   USING GIST ( the_geom GIST_GEOMETRY_OPS );
+
+
+
+
+alter table rht.rhtvs2_roev2 add column nbdams integer;
+update rht.rhtvs2_roev2 set nbdams=1;
+
+---Clause group by par id_bdcarthage
+select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 group by id_drain;
+
+drop table if exists rht.rht_bdcarthage_roev2_nbdams;
+create table rht.rht_bdcarthage_roev2_nbdams as
+select id_drain, count(nbdams) as nbdams from rht.rht_bdcarthage_roev2 as r group by id_drain;
 }}}