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 wie dit geadresseer is. Indien u
nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u
hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook
asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit.
Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of
uitgawe wat voortspruit uit hierdie 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 whom it is addressed. If you are not the
intended recipient, you are notified that you may not use, distribute or copy
this document in any manner whatsoever. Kindly also notify the sender
immediately by telephone, and delete the e-mail. The University does not accept
liability for any damage, loss or expense arising from this e-mail and/or
accessing any files attached to this e-mail.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
