Project

General

Profile

« Previous | Next » 

Revision 14870

Added by Aaron Marcuse-Kubitza about 10 years ago

bugfix: schemas/public_.sql: geoscrub_input_new: need to join on the ARRAY[] of each column, to compare NULLs properly

View differences:

trunk/schemas/public_.sql
8920 8920 
    geoscrub_input."decimalLatitude",
8921 8921 
    geoscrub_input."decimalLongitude"
8922 8922 
   FROM (geoscrub_input
8923 
   LEFT JOIN geoscrub.geoscrub_output ON ((((((geoscrub_output."decimalLatitude" = geoscrub_input."decimalLatitude") AND (geoscrub_output."decimalLongitude" = geoscrub_input."decimalLongitude")) AND (geoscrub_output.country = geoscrub_input.country)) AND (geoscrub_output."stateProvince" = geoscrub_input."stateProvince")) AND (geoscrub_output.county = geoscrub_input.county))))
8923 
   LEFT JOIN geoscrub.geoscrub_output ON ((((((ARRAY[geoscrub_output."decimalLatitude"] = ARRAY[geoscrub_input."decimalLatitude"]) AND (ARRAY[geoscrub_output."decimalLongitude"] = ARRAY[geoscrub_input."decimalLongitude"])) AND (ARRAY[geoscrub_output.country] = ARRAY[geoscrub_input.country])) AND (ARRAY[geoscrub_output."stateProvince"] = ARRAY[geoscrub_input."stateProvince"])) AND (ARRAY[geoscrub_output.county] = ARRAY[geoscrub_input.county]))))
8924 8924 
  WHERE (geoscrub_output."*row_num" IS NULL);
8925 8925 

  		




  8926
  8926
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  8920
  8920
  
    
    geoscrub_input."decimalLatitude",


  		




  8921
  8921
  
    
    geoscrub_input."decimalLongitude"


  		




  8922
  8922
  
    
   FROM (geoscrub_input


  		




  8923
  
  
    
   LEFT JOIN geoscrub.geoscrub_output ON ((((((geoscrub_output."decimalLatitude" = geoscrub_input."decimalLatitude") AND (geoscrub_output."decimalLongitude" = geoscrub_input."decimalLongitude")) AND (geoscrub_output.country = geoscrub_input.country)) AND (geoscrub_output."stateProvince" = geoscrub_input."stateProvince")) AND (geoscrub_output.county = geoscrub_input.county))))


  		




  
  8923
  
    
   LEFT JOIN geoscrub.geoscrub_output ON ((((((ARRAY[geoscrub_output."decimalLatitude"] = ARRAY[geoscrub_input."decimalLatitude"]) AND (ARRAY[geoscrub_output."decimalLongitude"] = ARRAY[geoscrub_input."decimalLongitude"])) AND (ARRAY[geoscrub_output.country] = ARRAY[geoscrub_input.country])) AND (ARRAY[geoscrub_output."stateProvince"] = ARRAY[geoscrub_input."stateProvince"])) AND (ARRAY[geoscrub_output.county] = ARRAY[geoscrub_input.county]))))


  		




  8924
  8924
  
    
  WHERE (geoscrub_output."*row_num" IS NULL);


  		




  8925
  8925
  
    

  		




  8926
  8926
  
    

  		












Also available in:  Unified diff