• Tom Lane's avatar
    Fix contrib/pg_trgm's similarity() function for trigram-free strings. · 9728eda7
    Tom Lane authored
    Cases such as similarity('', '') produced a NaN result due to computing
    0/0.  Per discussion, make it return zero instead.
    
    This appears to be the basic cause of bug #7867 from Michele Baravalle,
    although it remains unclear why her installation doesn't think Cyrillic
    letters are letters.
    
    Back-patch to all active branches.
    9728eda7
pg_trgm.sql 2.77 KB