Changes between Version 5 and Version 6 of Ticket #44
- Timestamp:
- Mar 2, 2010 6:00:20 PM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #44 – Description
v5 v6 39 39 ||36||-11560|| 40 40 ||86380||0|| 41 {{{ 42 drop table if exists tabledistance; 43 CREATE TABLE tabledistance AS( 44 select cum_len_sea-len_tom as diff, rivernodes.the_geom from rivernodes 45 inner join riversegments on riversegments.tonode=rivernodes.id 46 where cum_len_sea != len_tom); 47 alter table tabledistance add column id serial; 48 drop table tabledistance; 49 }}}
