Project

General

Profile

« Previous | Next » 

Revision 5185

Added by Aaron Marcuse-Kubitza about 12 years ago

inputs/.TNRS/schema.sql: tnrs: Added tnrs_accepted_names index, which sorts accepted names first, and cluster the table on this index. This ensures that the component-parsed entries for accepted names are created before any verbatim names that point to them.

View differences:

inputs/.TNRS/schema.sql
41 41 
WITH (
42 42 
  OIDS=FALSE
43 43 
);
44 
COMMENT ON TABLE tnrs
45 
  IS 'tnrs_accepted_names sorts accepted names first (note that false sorts before true). Accepted names are defined as names that scrub to themselves.';
46 

  		




  
  47
  
    
CREATE INDEX tnrs_accepted_names


  		




  
  48
  
    
  ON tnrs


  		




  
  49
  
    
  USING btree


  		




  
  50
  
    
  ((NOT "Name_submitted" = ("Accepted_name" || COALESCE(' '::text || "Accepted_name_author", ''::text))) , "Name_submitted" );


  		




  
  51
  
    
ALTER TABLE tnrs CLUSTER ON tnrs_accepted_names;


  		












Also available in:  Unified diff