From: Jaume Sabater <jsabater@linuxsilo.net>
To: pgsql-admin@postgresql.org
Subject: Re: Using text search for locations, or a computed btree index
Date: Thu, 4 Dec 2008 17:29:11 +0000 (GMT)
Message-ID: <26819476.7901228411751220.JavaMail.root@zimbra.linuxsilo.net> (raw)
In-Reply-To: <4119648.7881228411625043.JavaMail.root@zimbra.linuxsilo.net>
----- "Jaume Sabater" <jsabater@linuxsilo.net> wrote:
> The guys creating the web site at the company I work for want an
> incremental search for locations. So, I need to find all locations
> that start with Uni, then Unit, then Unite, and so on. Problem is that
Correct: start or contain.
> What I don't know how to do is to just tell tsvector (and tsquery when
> searching) to do what I need and not what I don't need. I can't find a
> way in the online documentation to tell the engine which pieces I want
> from the whole puzzle.
Rereading the configuration example section of the documentation, just thought that most probably PostgreSQL won't be applying the "phases" of normalization that I don't need if I create a new configuration and don't add any dictionary but the synonyms one (that would be used for the alternate names of locations).
Still, not sure how to control the way accented characters are converted. Will tsvector still convert accented characters to their non-accented equivalents if I don't specify any dictionary or thesaurus?
--
Jaume Sabater
http://linuxsilo.net/
"Ubi sapientas ibi libertas"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jsabater@linuxsilo.net
Subject: Re: Using text search for locations, or a computed btree index
In-Reply-To: <26819476.7901228411751220.JavaMail.root@zimbra.linuxsilo.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox