Re: [GENERAL] Incorrect FTS results with GIN index

2010-07-15 Thread Artur Dabrowski
My version of PostgreSQL is 8.4.3. -- View this message in context: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-tp29172750p29173652.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Incorrect FTS results with GIN index

2010-07-15 Thread Artur Dabrowski
I pasted incorrect query in point 5. It should be: 5. MORE DETAILED QUERY WITH INDEX select keywords from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', 'eeI:*')) and (to_tsvector('german', keywords ) @@ to_tsquery('german', 'dd:*'));