Re: [pg_trgm] Making similarity(?, ?) < ? use an index

Поиск
Список
Период
Сортировка
От Greg Navis
Тема Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Дата
Msg-id CAA6WWt8gHi0v5UxSBS=RhJKx2Nd7Tj8OuS0OKN01KR_JYbeHmw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pg_trgm] Making similarity(?, ?) < ? use an index  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [pg_trgm] Making similarity(?, ?) < ? use an index  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-general
Thanks for answers and sorry for not searching hard enough.

I'm curious ... would it be difficult to modify PostgreSQL so that it'd use the index for `similarity(lhs, rhs) >= show_limit()` too? Or even add `is_similar(lhs, rhs, threshold)` that'd allow to change the threshold on a per-query basis. I might be able to block some time to contribute.

Best regards
--
Greg Navis
I help tech companies to scale Heroku-hosted Rails apps.

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

Предыдущее
От: Leonardo M. Ramé
Дата:
Сообщение: Londiste3 - Ubuntu 16.04 - Postgresql 9.3
Следующее
От: Leonardo M. Ramé
Дата:
Сообщение: Re: Londiste3 - Ubuntu 16.04 - Postgresql 9.3