Op 16-08-2022 om 12:36 schreef Daniel Gustafsson:
On 16 Aug 2022, at 12:17, PG Doc comments form <nore...@postgresql.org> wrote:
I have a question regarding the trigram algorithm and I can not find any
information about it in your documentation:
Maybe we should add something about this?
Yeah, it's a bit strange that none of the following strings yield any
info on that page: 'case', 'sensitiv', 'upper', 'lower', and that there
is no mention of the ~ versus ~* difference.
Maybe worth to (already in pgtrgm.html) give the simple hint:
~ is case-sensitive
~* is case-insensitive
In any case a link to functions-matching.html seems indicated.
Erik Rijkers
Do you distinguish between lower and uppercase? Or do you consider all words
in lowercase?
There is support for compiling pg_trgm case sensitive, but it's by default case
insensitive.
# SELECT word_similarity('word', 'WORD');
word_similarity
-----------------
1
(1 row)
Happy to get a short feedback from you,
I would recommend the pg_general mailinglist as that will be a safer way to get
general questions answered.
--
Daniel Gustafsson https://vmware.com/
