Project

General

Profile

« Previous | Next » 

Revision 14266

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: taxon_match: added derived columns "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org", "[accepted_]infraspecificEpithet__@DwC__@vegpath.org"

View differences:

schema.sql
215 215 
		regexp_split_to_array(__accepted_infraspecific_label, ' '::text)
216 216 
		FROM (SELECT new.*) new);
217 217
218 
	new."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" = (SELECT
219 
		"__accepted_infraspecific_{rank,epithet}"[1]
220 
		FROM (SELECT new.*) new);
221
222 
	new."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" = (SELECT
223 
		"__accepted_infraspecific_{rank,epithet}"[2]
224 
		FROM (SELECT new.*) new);
225
218 226 
	RETURN new;
219 227 
END;
220 228 
$$;
......
350 358 
    "[accepted_]specificEpithet__@DwC__@vegpath.org" text,
351 359 
    __accepted_infraspecific_label text,
352 360 
    "__accepted_infraspecific_{rank,epithet}" text[],
361 
    "[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" text,
362 
    "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text,
363 
    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]))),
353 364 
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),
365 
    CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),
354 366 
    CONSTRAINT "[accepted_]specificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]specificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[2]))),
355 367 
    CONSTRAINT __accepted_infraspecific_label CHECK ((NOT (__accepted_infraspecific_label IS DISTINCT FROM ltrim(NULLIF(util.remove_prefix("*Accepted_name_species", "*Accepted_name", require := true), ''::text), ' '::text)))),
356 368 
    CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),
......
453 465 

  		




  454
  466
  
    

  		




  455
  467
  
    
--


  		




  
  468
  
    
-- Name: COLUMN taxon_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  469
  
    
--


  		




  
  470
  
    

  		




  
  471
  
    
COMMENT ON COLUMN taxon_match."[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org" IS '


  		




  
  472
  
    
derived column; = "__accepted_infraspecific_{rank,epithet}"[1]


  		




  
  473
  
    

  		




  
  474
  
    
to modify:


  		




  
  475
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]Infraspecific_rank[_abbr]__@TNRS__@vegpath.org'')::util.col, $$"__accepted_infraspecific_{rank,epithet}"[1]$$)::util.derived_col_def);


  		




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


  		




  
  477
  
    
';


  		




  
  478
  
    

  		




  
  479
  
    

  		




  
  480
  
    
--


  		




  
  481
  
    
-- Name: COLUMN taxon_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org"; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  482
  
    
--


  		




  
  483
  
    

  		




  
  484
  
    
COMMENT ON COLUMN taxon_match."[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS '


  		




  
  485
  
    
derived column; = "__accepted_infraspecific_{rank,epithet}"[2]


  		




  
  486
  
    

  		




  
  487
  
    
to modify:


  		




  
  488
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''[accepted_]infraspecificEpithet__@DwC__@vegpath.org'')::util.col, $$"__accepted_infraspecific_{rank,epithet}"[2]$$)::util.derived_col_def);


  		




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


  		




  
  490
  
    
';


  		




  
  491
  
    

  		




  
  492
  
    

  		




  
  493
  
    
--


  		




  456
  494
  
    
-- Name: taxon_best_match; Type: VIEW; Schema: TNRS; Owner: -


  		




  457
  495
  
    
--


  		




  458
  496
  
    

  		












Also available in:  Unified diff