wiki:CCM2 select

Version 4 (modified by cedric, 15 years ago) (diff)

--

-- Table: ccm21.seaoutlets
drop view v_selected;
create view v_selected as(
select gid,wso_id,the_geom from ccm21.seaoutlets where system_cd not in ('C','N','I','H','V')
except (select gid,wso_id,the_geom from ccm21.seaoutlets where 
system_cd = 'M' and sea_cd =5));



INSERT INTO geometry_columns(f_table_catalog, f_table_schema, f_table_name, f_geometry_column, coord_dimension, srid, "type")
SELECT '', 'public', 'v_selected', 'the_geom', ST_CoordDim(the_geom), ST_SRID(the_geom), GeometryType(the_geom)
FROM v_selected LIMIT 1;

source:data/Docs/trac/CCM21/selected_basins.jpg
Il seems that one basin is lacking in Turkey, not really a pb