pg_trgm.similarity

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: p0donn0fppz(at)gmail(dot)com
Subject: pg_trgm.similarity
Date: 2020-09-11 11:22:02
Message-ID: 159982332214.31332.1395077741619477865@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-docs by date

  From Date Subject
Next Message Robert Treat 2020-09-11 23:16:43 replication wordsmithing / clarifications
Previous Message PG Doc comments form 2020-09-11 08:45:41 Chapter 7. Queries