Project

General

Profile

« Previous | Next » 

Revision 14377

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: "[accepted_]genus__@DwC__@vegpath.org": don't need to use *Accepted_name anymore because _accepted{genus,specific_epithet,infra_{rank,epithet}} is now generated from *Accepted_name

View differences:

schema.sql
258 258 
END) FROM (SELECT new.*) new);
259 259 
	new."Accepted_species[_binomial]__@TNRS__@vegpath.org" = (SELECT rtrim("*Accepted_name_species", ' '::text) FROM (SELECT new.*) new);
260 260 
	new."__accepted_{genus,specific_epithet,infra_{rank,epithet}}" = (SELECT regexp_split_to_array("*Accepted_name", ' '::text) FROM (SELECT new.*) new);
261 
	new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT COALESCE("__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1],
262 
CASE
263 
    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"
264 
    ELSE NULL::text
265 
END) FROM (SELECT new.*) new);
261 
	new."[accepted_]genus__@DwC__@vegpath.org" = (SELECT "__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1] FROM (SELECT new.*) new);
266 262 
	new."[accepted_]specificEpithet__@DwC__@vegpath.org" = (SELECT "__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[2] FROM (SELECT new.*) new);
267 263 
	new."[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" = (SELECT CASE
268 264 
    WHEN ("*Accepted_name_rank" = 'family'::text) THEN concat_ws(' '::text, "Accepted_family__@TNRS__@vegpath.org", "[parsed_]morphospecies[_suffix]__@Brad__.morphosp@vegpath.org")
......
486 482 
END)))),
487 483 
    CONSTRAINT "Accepted_species[_binomial]__@TNRS__@vegpath.org" CHECK ((NOT ("Accepted_species[_binomial]__@TNRS__@vegpath.org" IS DISTINCT FROM rtrim("*Accepted_name_species", ' '::text)))),
488 484 
    CONSTRAINT "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" CHECK ((NOT ("[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[1]))),
489 
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM COALESCE("__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1],
490 
CASE
491 
    WHEN ("*Accepted_name_rank" = 'genus'::text) THEN "*Accepted_name"
492 
    ELSE NULL::text
493 
END)))),
485 
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1]))),
494 486 
    CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),
495 487 
    CONSTRAINT "[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" CHECK ((NOT ("[accepted_]morphospecies[_binomial]__@Brad__.TNRS@vegpath.org" IS DISTINCT FROM
496 488 
CASE
......
779 771 
--
780 772 

  		




  781
  773
  
    
COMMENT ON COLUMN taxon_match."[accepted_]genus__@DwC__@vegpath.org" IS '


  		




  782
  
  
    
= COALESCE("__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1],


  		




  783
  
  
    
CASE


  		




  784
  
  
    
    WHEN ("*Accepted_name_rank" = ''genus''::text) THEN "*Accepted_name"


  		




  785
  
  
    
    ELSE NULL::text


  		




  786
  
  
    
END)


  		




  
  774
  
    
= "__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1]


  		




  787
  775
  
    

  		




  788
  776
  
    
derived column


  		




  789
  777
  
    

  		




  790
  778
  
    
to modify expr:


  		




  791
  
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col, $$COALESCE("__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1],


  		




  792
  
  
    
CASE


  		




  793
  
  
    
    WHEN ("*Accepted_name_rank" = ''genus''::text) THEN "*Accepted_name"


  		




  794
  
  
    
    ELSE NULL::text


  		




  795
  
  
    
END)$$)::util.derived_col_def);


  		




  
  779
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]genus__@DwC__@vegpath.org'')::util.col, $$"__accepted_{genus,specific_epithet,infra_{rank,epithet}}"[1]$$)::util.derived_col_def);


  		




  796
  780
  
    
SELECT util.derived_cols_populate(''"TNRS".taxon_match''::regclass);


  		




  797
  781
  
    

  		




  798
  782
  
    
to rename:


  		












Also available in:  Unified diff