Re: [GENERAL] Incorrect FTS result with GIN index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Incorrect FTS result with GIN index
Дата
Msg-id 11087.1280412187@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Incorrect FTS result with GIN index  (Oleg Bartunov <oleg@sai.msu.su>)
Ответы Re: [GENERAL] Incorrect FTS result with GIN index  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-hackers
Oleg Bartunov <oleg@sai.msu.su> writes:
> I also wonder why did I get "right" result :) Just repeated the query:

> test=# select count(*) from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', 'ee:* &
dd:*'));
>   count 
> -------
>     123
> (1 row)

Yeah, that case works (though I think it's unnecessarily slow).  The one
that gives the wrong answer is the equivalent form with two AND'ed @@
operators.
        regards, tom lane


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: review: xml_is_well_formed
Следующее
От: Tom Lane
Дата:
Сообщение: Re: page corruption on 8.3+ that makes it to standby