Full-text search: Problems with dictionaries and periods

From: Theron Luhn <theron(at)luhn(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Full-text search: Problems with dictionaries and periods
Date: 2012-08-09 20:57:25
Message-ID: CAHYFdT9x3BJbnsqK1gUsn3Tw1ef+L02sC_-WWEAi+tNScyYA-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I made a custom synonym dictionary for my full-text search, using the
following code from the documentation.

CREATE TEXT SEARCH DICTIONARY my_synonym (
TEMPLATE = synonym,
SYNONYMS = my_synonyms
);

ALTER TEXT SEARCH CONFIGURATION english
ALTER MAPPING FOR asciiword WITH my_synonym, english_stem;

It works great, except on words with periods in them. For example, B.B.Q.:

=> select * from ts_debug('english', 'B.B.Q.');
alias | description | token | dictionaries | dictionary | lexemes
-------+-------------------+-------+--------------+------------+---------
file | File or path name | B.B.Q | {simple} | simple | {b.b.q}
blank | Space symbols | . | {} | |
(2 rows)

It interprets the string as a filename (that's what alias: file means,
right?), so the asciiword dictionary I set up above doesn't apply.

How can I change this?

— Theron

Browse pgsql-general by date

  From Date Subject
Next Message Anibal David Acosta 2012-08-10 05:31:05 change column data type of a big table
Previous Message Mike Blackwell 2012-08-09 18:02:24 Re: Revoking table & function creation privileges