FTS prefix search - put full hits first

[cen <imbacen@xxxxxxxxx>]

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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general