CODEWITHSUNDEEP
postgresql
Armin
Armin

Reputation: 1

Postgresql fulltext search for words with few specific chars

here is problem. When execute this:

select to_tsvector('simple', 'a.')

I god just one result: 'a' because "." is a "Space symbol"

So, my question is what is the best way to remove a few chars from a space symbol list, for this (simple) dictionary or another (newly created). I can not find system db, or a file where postgresql store those symbols.

Upvotes: 0

Views: 331

Answers (1)

Suor
Suor

Reputation: 3045

First you need to create your custom text search configuration

CREATE TEXT SEARCH CONFIGURATION your_fts (
    PARSER = pg_catalog."default" );

and then add a mapping for blank tokens

ALTER TEXT SEARCH CONFIGURATION name
    ALTER MAPPING FOR blank WITH simple;

This way you all spaces and special chars will go to tsvectors. Which is probably not what you want. You will need to use custom dictionary or even custom parser to distinguish your few special chars.

Upvotes: 1

Related Questions