Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries
Дата
Msg-id CA+TgmobvsL35sRPJ8BjHgTkPMZssTL03iO4xY2nMkxje0t5XxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Wed, May 29, 2013 at 10:51 PM, Amit Langote <amitlangote09@gmail.com> wrote:
> So, it appears, for search strings consisting of 2 (or < 3)
> characters, trigrams can not be utilized. No?

I think that's right.  "trigram" means a sequence of three characters,
and what's stored in the indexes are three-character sequences from
the original text.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: pg_dump with postgis extension dumps rules separately
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries