| From: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
|---|---|
| To: | marcmaiwald(at)googlemail(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Lower or Upper case for F.33. pg_trgm |
| Date: | 2022-08-16 10:36:20 |
| Message-ID: | 65FB8525-EB15-4A22-B204-51385A088D64@yesql.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
> 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?
> 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Erik Rijkers | 2022-08-16 10:54:10 | Re: Lower or Upper case for F.33. pg_trgm |
| Previous Message | PG Doc comments form | 2022-08-16 10:17:24 | Lower or Upper case for F.33. pg_trgm |