Changes between Version 3 and Version 4 of CookBook join Temperature_CCM
- Timestamp:
- May 11, 2010 5:23:16 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
CookBook join Temperature_CCM
v3 v4 10 10 {{{ 11 11 DROP TABLE IF EXISTS temperature.tmp_ccm; 12 12 13 CREATE TABLE temperature.tmp_ccm as( 13 14 SELECT gridid, gid, min(distance) as distance, the_geom FROM ( … … 31 32 {{{ 32 33 DROP TABLE IF EXISTS temperature.tmx_ccm; 34 33 35 CREATE TABLE temperature.tmx_ccm as( 34 36 SELECT gridid, gid, min(distance) as distance, the_geom FROM ( … … 52 54 {{{ 53 55 DROP TABLE IF EXISTS temperature.tmn_ccm; 56 54 57 CREATE TABLE temperature.tmn_ccm as( 55 58 SELECT gridid, gid, min(distance) as distance, the_geom FROM (