Re: Full text search ts_heading strange result

Поиск
Список
Период
Сортировка
От Johann Spies
Тема Re: Full text search ts_heading strange result
Дата
Msg-id 20120726061429.GB7012@sun.ac.za
обсуждение исходный текст
Ответ на Re: Full text search ts_heading strange result  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Full text search ts_heading strange result  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
Hallo Tom,

> I believe the problem is that the one-argument form of to_tsquery() uses
> the default TS configuration, which you have probably not got set to
> "simple".  For me, the default TS configuration is "english", which will
> stem "polity" as "politi":
>
> regression=# select to_tsquery('(polity & church)');
>      to_tsquery
> ---------------------
>  'politi' & 'church'
> (1 row)
>
> However the "simple" configuration doesn't do anything to that lexeme:

Thanks for the explanation.  I am working with a multi-language database
and that was the reason for using the 'simple' configuration.

I have asked, in an earlier message on this list, advice on how to
handle full text searches in a multi-language database, but got no
reaction to it.  If there is a better way than using the 'simple'
configuration in this case, I would gladly try it.

Regards
Johann.

--
Johann Spies                            Telefoon: 021-808 4699
Databestuurder /  Data manager

Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie
Centre for Research on Evaluation, Science and Technology
Universiteit Stellenbosch.

     "If any of you lack wisdom, let him ask of God, that
      giveth to all men liberally, and upbraideth not; and
      it shall be given him."              James 1:5
E-pos vrywaringsklousule

Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan
wiedit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie
dokumentgeensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis
envee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit
uithierdie e-pos en/of die oopmaak van enige l��s aangeheg by hierdie e-pos nie. 

E-mail disclaimer

This e-mail may contain confidential information and may be legally privileged and is intended only for the person to
whomit is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy
thisdocument in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail.
TheUniversity does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any
filesattached to this e-mail. 

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

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: Smaller data types use same disk space
Следующее
От: saleem
Дата:
Сообщение: Re: FATAL: no pg_hba.conf entry for host “::1”