Project

General

Profile

« Previous | Next » 

Revision 10320

Added by Aaron Marcuse-Kubitza over 11 years ago

inputs/ACAD/Specimen/postprocess.sql, inputs/ARIZ/omoccurrences/postprocess.sql: removed unnecessary "" around keys/values. "" are required in hstore input syntax in approximately the same places as they are in XPaths (around values containing spaces or special characters).

View differences:

inputs/ACAD/Specimen/postprocess.sql
1 1 
SELECT util.search_path_append('util');
2 2 

  		




  3
  3
  
    
SELECT mk_derived_col((:table_str, 'specimenHolderInstitutions'),


  		




  4
  
  
    
$$_map('"Acadia University"=>"ACAD", "*"=>"*"', "specimenHolderInstitutions_verbatim")$$);


  		




  
  4
  
    
$$_map('"Acadia University"=>ACAD, *=>*', "specimenHolderInstitutions_verbatim")$$);


  		












  

    
      inputs/ARIZ/omoccurrences/postprocess.sql
    
  





  2
  2
  
    

  		




  3
  3
  
    
-- cultivated can only be true or NULL, not false


  		




  4
  4
  
    
SELECT mk_derived_col((:table_str, 'cultivated'),


  		




  5
  
  
    
$$_map('"0"=>NULL, "*"=>"*"', "cultivated_verbatim")$$);


  		




  
  5
  
    
$$_map('0=>NULL, *=>*', "cultivated_verbatim")$$);


  		












Also available in:  Unified diff