From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: p0donn0fppz@gmail.com
Subject: pg_trgm.similarity
Date: Fri, 11 Sep 2020 11:22:02 +0000
Message-ID: <159982332214.31332.1395077741619477865@wrigleys.postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, p0donn0fppz@gmail.com
Subject: Re: pg_trgm.similarity
In-Reply-To: <159982332214.31332.1395077741619477865@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox