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@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/
> 
> 
>