Project

General

Profile

« Previous | Next » 

Revision 9988

Added by Aaron Marcuse-Kubitza over 11 years ago

bugfix: inputs/.TNRS/schema.sql: tnrs_populate_fields(): need to schema-qualify invoked functions

View differences:

inputs/.TNRS/schema.sql
98 98 
        ELSE NULL -- ambiguous
99 99 
        END);
100 100 
    never_homonym boolean = COALESCE(new."Author_score" >= 0.6, false); -- author disambiguates
101 
    family_is_homonym boolean = NOT never_homonym AND family_is_homonym(new."Family_matched");
102 
    genus_is_homonym  boolean = NOT never_homonym AND genus_is_homonym( new."Genus_matched" );
101 
    family_is_homonym boolean = NOT never_homonym AND "TNRS".family_is_homonym(new."Family_matched");
102 
    genus_is_homonym  boolean = NOT never_homonym AND "TNRS".genus_is_homonym( new."Genus_matched" );
103 103 
BEGIN
104 104 
    new."Accepted_scientific_name" = NULLIF(concat_ws(' '
105 105 
        , NULLIF(NULLIF(new."Accepted_name_family", 'Unknown'), new."Accepted_name")

Also available in: Unified diff