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

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: Lower or Upper case for F.33. pg_trgm
Дата
Msg-id 65FB8525-EB15-4A22-B204-51385A088D64@yesql.se
обсуждение исходный текст
Ответ на Lower or Upper case for F.33. pg_trgm  (PG Doc comments form <noreply@postgresql.org>)
Ответы Re: Lower or Upper case for F.33. pg_trgm  (Erik Rijkers <er@xs4all.nl>)
Список pgsql-docs
> 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?

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




В списке pgsql-docs по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: Lower or Upper case for F.33. pg_trgm
Следующее
От: Erik Rijkers
Дата:
Сообщение: Re: Lower or Upper case for F.33. pg_trgm