Project

General

Profile

« Previous | Next » 

Revision 14521

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: schemas/public_.sql: native_status_resolver: remove the id because this prevents SELECT DISTINCT from having the desired effect. instead, the results will be joined back using the other columns.

View differences:

vegbien.sql
10644 10644 
--
10645 10645 

  		




  10646
  10646
  
    
CREATE VIEW native_status_resolver AS


  		




  10647
  
  
    
 SELECT DISTINCT view_full_occurrence_individual.taxonobservation_id AS id,


  		




  10648
  
  
    
    view_full_occurrence_individual.scrubbed_family AS family,


  		




  
  10647
  
    
 SELECT DISTINCT view_full_occurrence_individual.scrubbed_family AS family,


  		




  10649
  10648
  
    
    view_full_occurrence_individual.scrubbed_genus AS genus,


  		




  10650
  10649
  
    
    view_full_occurrence_individual.scrubbed_species_binomial AS species_binomial,


  		




  10651
  10650
  
    
    view_full_occurrence_individual.country,


  		












Also available in:  Unified diff