Project

General

Profile

« Previous | Next » 

Revision 14277

Added by Aaron Marcuse-Kubitza over 10 years ago

inputs/.TNRS/schema.sql: _matched_has_accepted: renamed to matched_has_accepted because the leading _ did not create vertical alignment anyway, due to different quoting syntaxes

View differences:

trunk/inputs/.TNRS/schema.sql
231 231 
		"*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text)
232 232 
		FROM (SELECT new.*) new);
233 233
234 
	new._matched_has_accepted = (SELECT
234 
	new.matched_has_accepted = (SELECT
235 235 
		"*Accepted_name" IS NOT NULL
236 236 
		FROM (SELECT new.*) new);
237 237
......
374 374 
    "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text,
375 375 
    "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" text,
376 376 
    "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text,
377 
    _matched_has_accepted boolean,
377 
    matched_has_accepted boolean,
378 378 
    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]))),
379 379 
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),
380 380 
    CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),
......
384 384 
    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)))),
385 385 
    CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),
386 386 
    CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("*Accepted_name_species", ' '::text)))),
387 
    CONSTRAINT _matched_has_accepted CHECK ((NOT (_matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))
387 
    CONSTRAINT matched_has_accepted CHECK ((NOT (matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))
388 388 
);
389 389 

  		




  390
  390
  
    

  		




  ......




  580
  580
  
    

  		




  581
  581
  
    

  		




  582
  582
  
    
--


  		




  583
  
  
    
-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  583
  
    
-- Name: COLUMN taxon_match.matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -


  		




  584
  584
  
    
--


  		




  585
  585
  
    

  		




  586
  
  
    
COMMENT ON COLUMN taxon_match._matched_has_accepted IS '


  		




  
  586
  
    
COMMENT ON COLUMN taxon_match.matched_has_accepted IS '


  		




  587
  587
  
    
derived column; = "*Accepted_name" IS NOT NULL


  		




  588
  588
  
    

  		




  589
  589
  
    
to modify expr:


  		




  590
  
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''_matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);


  		




  
  590
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);


  		




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


  		




  592
  592
  
    

  		




  593
  593
  
    
to rename:


  		












  

    
      trunk/schemas/vegbien.my.sql
    
  





  15472
  15472
  
    
    `[accepted_]infraspecificEpithet__@DwC__@vegpath.org` varchar(255),


  		




  15473
  15473
  
    
    `[matched_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255),


  		




  15474
  15474
  
    
    `[accepted_]scientificName[_with_author]__@DwC__@vegpath.org` varchar(255),


  		




  15475
  
  
    
    _matched_has_accepted int(1)


  		




  
  15475
  
    
    matched_has_accepted int(1)


  		




  15476
  15476
  
    
);


  		




  15477
  15477
  
    

  		




  15478
  15478
  
    

  		




  ......




  15547
  15547
  
    

  		




  15548
  15548
  
    

  		




  15549
  15549
  
    
--


  		




  15550
  
  
    
-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  15550
  
    
-- Name: COLUMN taxon_match.matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -


  		




  15551
  15551
  
    
--


  		




  15552
  15552
  
    

  		




  15553
  15553
  
    

  		












  

    
      trunk/schemas/vegbien.sql
    
  





  19301
  19301
  
    
		"*Accepted_name" || COALESCE((' '::text || "*Accepted_name_author"), ''::text)


  		




  19302
  19302
  
    
		FROM (SELECT new.*) new);


  		




  19303
  19303
  
    
	


  		




  19304
  
  
    
	new._matched_has_accepted = (SELECT


  		




  
  19304
  
    
	new.matched_has_accepted = (SELECT


  		




  19305
  19305
  
    
		"*Accepted_name" IS NOT NULL


  		




  19306
  19306
  
    
		FROM (SELECT new.*) new);


  		




  19307
  19307
  
    
	


  		




  ......




  19486
  19486
  
    
    "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" text,


  		




  19487
  19487
  
    
    "[matched_]scientificName[_with_author]__@DwC__@vegpath.org" text,


  		




  19488
  19488
  
    
    "[accepted_]scientificName[_with_author]__@DwC__@vegpath.org" text,


  		




  19489
  
  
    
    _matched_has_accepted boolean,


  		




  
  19489
  
    
    matched_has_accepted boolean,


  		




  19490
  19490
  
    
    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]))),


  		




  19491
  19491
  
    
    CONSTRAINT "[accepted_]genus__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]genus__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_{genus,specific_epithet}"[1]))),


  		




  19492
  19492
  
    
    CONSTRAINT "[accepted_]infraspecificEpithet__@DwC__@vegpath.org" CHECK ((NOT ("[accepted_]infraspecificEpithet__@DwC__@vegpath.org" IS DISTINCT FROM "__accepted_infraspecific_{rank,epithet}"[2]))),


  		




  ......




  19496
  19496
  
    
    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)))),


  		




  19497
  19497
  
    
    CONSTRAINT "__accepted_infraspecific_{rank,epithet}" CHECK ((NOT ("__accepted_infraspecific_{rank,epithet}" IS DISTINCT FROM regexp_split_to_array(__accepted_infraspecific_label, ' '::text)))),


  		




  19498
  19498
  
    
    CONSTRAINT "__accepted_{genus,specific_epithet}" CHECK ((NOT ("__accepted_{genus,specific_epithet}" IS DISTINCT FROM regexp_split_to_array("*Accepted_name_species", ' '::text)))),


  		




  19499
  
  
    
    CONSTRAINT _matched_has_accepted CHECK ((NOT (_matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))


  		




  
  19499
  
    
    CONSTRAINT matched_has_accepted CHECK ((NOT (matched_has_accepted IS DISTINCT FROM ("*Accepted_name" IS NOT NULL))))


  		




  19500
  19500
  
    
);


  		




  19501
  19501
  
    

  		




  19502
  19502
  
    

  		




  ......




  19692
  19692
  
    

  		




  19693
  19693
  
    

  		




  19694
  19694
  
    
--


  		




  19695
  
  
    
-- Name: COLUMN taxon_match._matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -


  		




  
  19695
  
    
-- Name: COLUMN taxon_match.matched_has_accepted; Type: COMMENT; Schema: TNRS; Owner: -


  		




  19696
  19696
  
    
--


  		




  19697
  19697
  
    

  		




  19698
  
  
    
COMMENT ON COLUMN taxon_match._matched_has_accepted IS '


  		




  
  19698
  
    
COMMENT ON COLUMN taxon_match.matched_has_accepted IS '


  		




  19699
  19699
  
    
derived column; = "*Accepted_name" IS NOT NULL


  		




  19700
  19700
  
    

  		




  19701
  19701
  
    
to modify expr:


  		




  19702
  
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''_matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);


  		




  
  19702
  
    
SELECT util.derived_col_update(((''"TNRS".taxon_match'', ''matched_has_accepted'')::util.col, $$"*Accepted_name" IS NOT NULL$$)::util.derived_col_def);


  		




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


  		




  19704
  19704
  
    

  		




  19705
  19705
  
    
to rename:


  		












Also available in:  Unified diff