From: | Dane Foster <studdugie(at)gmail(dot)com> |
---|---|
To: | Johann Höchtl <johann(dot)hoechtl(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Full text search question: "01.Bez." --> "Erster Bezirk" |
Date: | 2016-03-13 17:32:12 |
Message-ID: | CA+WxinLhEhrRsci+PAgEJBbNHeJHQdop8LLs0SBbEqOQfhJbgA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
On Sat, Mar 12, 2016 at 11:40 AM, Johann Höchtl <johann(dot)hoechtl(at)gmail(dot)com>
wrote:
> I fear I have an involved challenge concerning FTS.
>
> Assume I have the following text in a column:
>
> Graz,06.Bez.:Blah
>
> This parses as:
> SELECT alias, description, token FROM ts_debug('german',
> 'Graz,06.Bez.:Blah');
> alias | description | token
> -----------+-----------------+--------
> asciiword | Word, all ASCII | Graz
> blank | Space symbols | ,
> host | Host | 06.Bez
> blank | Space symbols | .:
> asciiword | Word, all ASCII | Blah
>
>
> Bez. ist the abbreviation for "Bezirk" (german for ~district). 06.Bez
> means "6th district"
>
> My first problem might be that the parser identifies "06.Bez." as a host
> lexeme, but ...
>
> I already defined a synonym dictionary to enable searching for "Bezirk",
> when there is only "Bez." in the database:
>
> file: bevaddress_host.syn:
> 01.bez bezirk
> 06.bez bezirk
> <snip some more rows>
>
>
> CREATE TEXT SEARCH DICTIONARY bevaddress_host_syn (
> TEMPLATE = synonym,
> SYNONYMS = bevaddress_host
> );
> ALTER TEXT SEARCH CONFIGURATION german ALTER MAPPING FOR host WITH
> bevaddress_host_syn, simple;
>
>
> I wonder how I can achieve to be able to search for "Erster Bezirk"
> ("First district") to match eg. "01.Bez."
>
> Thank you for your help, Johann
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
As of the time of writing this I haven't seen any replies to your post so
you may not be aware that an answer was provided to your specific question
in a blog. http://obartunov.livejournal.com/185579.html
Regards,
Dane
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2016-03-13 18:05:19 | Re: pg_restore fails |
Previous Message | Tom Lane | 2016-03-13 17:15:49 | Re: "brew services list" shows postgresql as "started", but can not connect to it |