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
