pg_trgm.similarity

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема pg_trgm.similarity
Дата
Msg-id 159982332214.31332.1395077741619477865@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/pgtrgm.html
Description:

https://www.postgresql.org/docs/12/pgtrgm.html states that "similarity(text,
text)     real     Returns a number that indicates how similar the two arguments
are. The range of the result is zero (indicating that the two strings are
completely dissimilar) to one (indicating that the two strings are
identical)."
The word identical is incorrect or at least misleading. It should say
"identical under trigram permutation" or the like.
Remark that the following two strings are not (strictly) identical, yet
their similarity() score is 1:
SELECT similarity('aaabaaa', 'aabaaa');

Moreover, a definition of the formula of computation of that function is
missing.

Sincerely, 
Paul.

В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Chapter 7. Queries
Следующее
От: Robert Treat
Дата:
Сообщение: replication wordsmithing / clarifications