Project

General

Profile

« Previous | Next » 

Revision 9921

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/.geoscrub/geoscrub_output/postprocess.sql: set decimallatitude, decimallongitude types to double precision to facilitate joining with other double precision values

View differences:

postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  
  3
  
    
-- runtime: 25 s ("real 0m21.770s")


  		




  
  4
  
    
SELECT set_col_types(:table_str, ARRAY[


  		




  
  5
  
    
  ('decimallatitude', 'double precision')


  		




  
  6
  
    
, ('decimallongitude', 'double precision')


  		




  
  7
  
    
]::col_cast[]);


  		




  
  8
  
    

  		




  3
  9
  
    
ALTER TABLE :table ALTER COLUMN decimallatitude SET NOT NULL;


  		




  4
  10
  
    
ALTER TABLE :table ALTER COLUMN decimallongitude SET NOT NULL;


  		




  5
  11
  
    

  		












Also available in:  Unified diff