Project

General

Profile

« Previous | Next » 

Revision 12367

Added by Aaron Marcuse-Kubitza over 10 years ago

fix: schemas/vegbien.sql: _traits_08_taxonname_trait_and_value_for_first_5000_records: renamed to _traits_08_taxonname_trait_and_value because this actually includes all the records, not just the first 5000. this uses the new public_validations.rename_query_view() to rename all associated tables and views, including handling truncated names.

View differences:

validations.sql
90 90 

  		




  91
  91
  
    

  		




  92
  92
  
    
--


  		




  93
  
  
    
-- Name: _traits_08_taxonname_trait_and_value_for_first_5000_records; Type: VIEW; Schema: bien2_traits; Owner: -


  		




  
  93
  
    
-- Name: _traits_08_taxonname_trait_and_value; Type: VIEW; Schema: bien2_traits; Owner: -


  		




  94
  94
  
    
--


  		




  95
  95
  
    

  		




  96
  
  
    
CREATE VIEW _traits_08_taxonname_trait_and_value_for_first_5000_records AS


  		




  
  96
  
    
CREATE VIEW _traits_08_taxonname_trait_and_value AS


  		




  97
  97
  
    
 SELECT btrim(concat_ws(' '::text, ifnull("TraitObservation"."taxonName", ''::text), ifnull("TraitObservation"."scientificNameAuthorship", ''::text))) AS taxonwithauthor, 


  		




  98
  98
  
    
    "TraitObservation"."measurementName" AS trait, 


  		




  99
  99
  
    
    "TraitObservation"."measurementValue" AS value


  		












Also available in:  Unified diff