Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Incorrect FTS result with GIN index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Teodor Sigaev <teodor(at)sigaev(dot)ru>, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [GENERAL] Incorrect FTS result with GIN index
Date: 2010-07-29 14:03:07
Message-ID: 11087.1280412187@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
Oleg Bartunov <oleg(at)sai(dot)msu(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2010-07-29 14:35:02
Subject: Re: page corruption on 8.3+ that makes it to standby
Previous:From: Pavel StehuleDate: 2010-07-29 13:21:55
Subject: review: xml_is_well_formed

pgsql-general by date

Next:From: Merlin MoncureDate: 2010-07-29 14:06:58
Subject: Re: Danger of idiomatic plpgsql loop for merging data
Previous:From: venkatDate: 2010-07-29 12:58:26
Subject: How to get geometry enabled Tables form Postgresql/postgis

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group