Re: Lower or Upper case for F.33. pg_trgm

Op 16-08-2022 om 12:36 schreef Daniel Gustafsson:
>> On 16 Aug 2022, at 12:17, PG Doc comments form <noreply(at)postgresql(dot)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/
>
>
>