Changes between Version 9 and Version 10 of CookBook join RHT-BDMAP

Timestamp:

May 23, 2011 2:57:12 PM (14 years ago)

Author:

celine

Comment:

--

CookBook join RHT-BDMAP

@@ -52 +52 @@
 
 DROP table if exists rht.bdmap_rht_id;
-CREATE TABLE rht.bdmap_rht_id (
+CREATE TABLE rht.bdmap_rht_id as (
 select distinct on (st_codecsp) * from rht.bdmap_rht
 );
-delete from rht.bdmap_rht_id where id_drain in ('03760141','03270131','01620009','01620005','01620137','01590014','06890285','06210238','03890095','02570237','02670291','02670264','02670097','02670092','02670098','02670230','02670231','02670232','02680172','02680166','02680039','02680033','02680037','02680144','02680143');
+delete from rht.bdmap_rht_id where st_codecsp in ('03760141','03270131','01620009','01620005','01620137','01590014','06890285','06210238','03890095','02570237','02670291','02670264','02670097','02670092','02670098','02670230','02670231','02670232','02680172','02680166','02680039','02680033','02680037','02680144','02680143');  -- 25 stations supprimées
 }}}