In a postsgresql v13 database, I want to add a search vector on a table, and i want to put several columns (not all the same type) in that vector.
I have some 7 text columns, 1 json column and 1 jsonb column :/

I have a task of full-text search in fields that may contain Russian, English and mixed phrases. User input assumes that the query contains words in both languages. At the same time, I would like the words from the query to be searched by OR.

I am trying to construct a full text search where half words should be matched. In my example, the column value is ‘offer’ and the search term is ‘off’. I construct the query like this. The first line does NOT return the row, but the second line does.