]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 06af3f9) | patch
Fix contrib/pg_trgm's similarity() function for trigram-free strings.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 13 Feb 2013 19:07:26 +0000 (14:07 -0500)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 13 Feb 2013 19:07:26 +0000 (14:07 -0500)
commit697f5cadf5d81eeee3f3018d711ef33261dc7cd5
tree3c736f0a8e9eb1e8f4e707db6b7a9d5607003eb6tree | snapshot
parent06af3f96568646e7f878622bfa6e73f9eaa5f3f0commit | diff
Fix contrib/pg_trgm's similarity() function for trigram-free strings.

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.
contrib/pg_trgm/expected/pg_trgm.out diff | blob | history
contrib/pg_trgm/sql/pg_trgm.sql diff | blob | history
contrib/pg_trgm/trgm_op.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.