Re: [GENERAL] Incorrect FTS result with GIN index - Mailing list 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