Re: Incorrect FTS query results with GIN index

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: Incorrect FTS query results with GIN index
Дата
Msg-id 4B544C48.5080203@sigaev.ru
обсуждение исходный текст
Ответ на Incorrect FTS query results with GIN index  (Vyacheslav Kalinin <vka@mgcp.com>)
Ответы Re: Incorrect FTS query results with GIN index  (Vyacheslav Kalinin <vka@mgcp.com>)
Список pgsql-general
> Basically, I started testing prefix matching in FTS and got into
> troubles. Self-contained example follows:

Thank you, fixed. The reason was in incorrect optimization of GIN scan: GIN
reuses scan result for equals key, but comparison of key didn't take into
account a difference of scan's strategy.


--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

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

Предыдущее
От: Brian
Дата:
Сообщение: does ispell have allaffixes set to on?
Следующее
От: Vyacheslav Kalinin
Дата:
Сообщение: Re: Incorrect FTS query results with GIN index