Project

General

Profile

« Previous | Next » 

Revision 11618

Added by Aaron Marcuse-Kubitza about 11 years ago

inputs/.TNRS/schema.sql: tnrs_populate_fields(): is_valid_match: don't consider Max_score because Is_plant will always be false when the Max_score is insufficient (<0.8)

View differences:

schema.sql
135 135 
            END)
136 136 
        END);
137 137 
    /* exclude homonyms because these are not valid matches (i.e. TNRS provides
138 
    a name, but the name is not meaningful because it is not unambiguous) */
139 
    new.is_valid_match = COALESCE("TNRS".score_ok(new."Max_score"), false)
140 
        AND COALESCE(new."Is_plant", false);
138 
    a name, but the name is not meaningful because it is not unambiguous).
139 
    don't need to consider Max_score because Is_plant will always be false when
140 
    the Max_score is insufficient (<0.8). */
141 
    new.is_valid_match = COALESCE(new."Is_plant", false);
141 142
142 143 
    RETURN new;
143 144 
END;

Also available in: Unified diff