Changes between Version 13 and Version 14 of Cookbook CCM21_France

Timestamp:

May 27, 2010 4:48:00 PM (15 years ago)

Author:

cedric

Comment:

--

Cookbook CCM21_France

@@ -18 +18 @@
  -- a table containing three columns 
 {{{
+#!sql
  drop table  if exists france.wso;
  CREATE TABLE france.wso (
@@ -26 +27 @@
 }}}
 {{{
+#!sql
 insert into france.wso(wso_id) 
 select distinct on (wso_id)  wso_id from ccm21.riversegments r
@@ -36 +38 @@
 
 {{{
+#!sql
 select * from ccm21.riversegments where wso_id in (select wso_id from france.wso where area='France')--170703 lines
 }}}
 
 {{{
+#!sql
 CREATE INDEX france_wso_id
   ON france.wso