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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [pg_trgm] Making similarity(?, ?) < ? use an index
Дата
Msg-id 13279.1465480564@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Greg Navis <contact@gregnavis.com>)
Ответы Re: [pg_trgm] Making similarity(?, ?) < ? use an index  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Greg Navis <contact@gregnavis.com> writes:
> I'm not sure how to make this operator use an index. It seems I need to
> create an operator class but I'm not sure how.

What you'd want to do is add it to the existing operator class and then
teach the class's support functions (mostly, the "consistent" function)
about it.

            regards, tom lane


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

Предыдущее
От: Michael McInness
Дата:
Сообщение: Re: connection pooling, many users, many datasources
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [pg_trgm] Making similarity(?, ?) < ? use an index