Answer the question
In order to leave comments, you need to log in
How to rank exact occurrences higher in PostgreSQL?
For example, there are entries, for example: "Stephen" and "Steve".
If you make such a request, then the records have the same weight and they can be in the output in any order.
SELECT * FROM offers WHERE to_tsvector('russian', name) @@ plainto_tsquery('russian', 'стивен');
# select to_tsvector('russian', 'стивен');
-[ RECORD 1 ]---------
to_tsvector | 'стив':1
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question