Project

General

Profile

« Previous | Next » 

Revision 11606

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: tnrs: added is_valid_match derived column, to make it easier to select from only those TNRS results that can safely be used as a scrubbed name

View differences:

schema.sql
113 113 
            ELSE NULL -- ambiguous
114 114 
            END)
115 115 
        END);
116 
    new.is_valid_match = COALESCE("TNRS".score_ok(new."Max_score"), false)
117 
        AND COALESCE(new."Is_plant", false);
116 118
117 119 
    RETURN new;
118 120 
END;
......
179 181 
    "Accepted_scientific_name" text,
180 182 
    "Max_score" double precision,
181 183 
    "Is_homonym" boolean,
182 
    "Is_plant" boolean
184 
    "Is_plant" boolean,
185 
    is_valid_match boolean NOT NULL
183 186 
);
184 187 

  		




  185
  188
  
    

  		












Also available in:  Unified diff