Hi I have this FTS query:
SELECT * FROM receivers r WHERE r.tsv @@ unaccent('john:*')::tsquery ORDER BY ts_rank(r.tsv, unaccent('john:*')::tsquery) DESC;
Is there any way to tell FTS to put records with "John" first and others after that (Johhny, Johnson etc)?
Basically, I want to have full word hits on top. Best regards, Klemen -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
