Re: text search patch status update?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: text search patch status update?
Дата
Msg-id 200901080150.n081oKX20489@momjian.us
обсуждение исходный текст
Ответ на Re: text search patch status update?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: text search patch status update?
Re: text search patch status update?
Список pgsql-hackers
Uh, where are we on this?  I see the same output in CVS HEAD as Heikki,
and I assume he thought at least one of them was wrong.  ;-)

---------------------------------------------------------------------------

Heikki Linnakangas wrote:
> Sushant Sinha wrote:
> > Patch #2. I think this is a straigt forward bug fix.
> 
> Yes, I think you're right. In hlCover(), *q is 0 when the only match is 
> the first item in the text, and we shouldn't bail out with "return 
> false" in that case.
> 
> But there seems to be something else going on here as well:
> 
> postgres=# select ts_headline('1 2 3 4 5', '2'::tsquery, 'MinWords=2, 
> MaxWords=3');
>   ts_headline
> --------------
>   <b>2</b> 3 4
> (1 row)
> 
> postgres=# select ts_headline('aaa1 aaa2 aaa3 aaa4 
> aaa5','aaa2'::tsquery, 'MinWords=2, MaxWords=3');
>     ts_headline
> ------------------
>   <b>aaa2</b> aaa3
> (1 row)
> 
> In the first example, you get three words, and in the 2nd, just two. It 
> must be because of the default ShortWord setting of 3. Also, if only the 
> last word matches, and it's a "short word", you get the whole text:
> 
> postgres=# select ts_headline('1 2 3 4 5','5'::tsquery, 'MinWords=2, 
> MaxWords=3');
>     ts_headline
> ------------------
>   1 2 3 4 <b>5</b>
> (1 row)
> 
> -- 
>    Heikki Linnakangas
>    EnterpriseDB   http://www.enterprisedb.com
> 
> -- 
> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Potential Join Performance Issue
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: New patch for Column-level privileges