V
V
Vladimir Sergeevich2016-11-01 16:23:21
PostgreSQL
Vladimir Sergeevich, 2016-11-01 16:23:21

How not to lose a word if it is not found in the dictionary (Postgresql Full Text Search)?

Peace for everyone! And another question from me.
It concerns mostly those who have already worked with Postgresql full-text search
And the question is this:
There is some full-text search config it uses several dictionaries and there is the word "Volume" (for example) the problem is that none of the dictionaries gives me for this word is a token.
As a result, on request:
SELECT * FROM ts_debug('ru','Том');
I get an empty array
3c0b7c07f51f47a09d262186c7e3406d.png
. And I would like that if the word was not found, then it would be in its pure form (with a case change) in tokens. What is the best way to do this?
In addition, a link to Youtube with a question: https://www.youtube.com/watch?v=7243AxgDAgc (Sorry for the confusion)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
igoo, 2016-11-01
@VladimirZhid

ts_debug('simple', 'volume') - look up the simple dictionary

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question