PostgresqlPostgres' full text search to_tsvector()to_tsvector()
function returns a sorted array of lexemes. I need exactly the same functionthat, but returning unsorted array ofjust with lexemes in original sort order. Is there any such postgresqlPostgres function already available, or do I need to do it myself? How to do itIs so, how?
I need it for Jaro-Winkler string similarity function, for which order of strings/words is important...I I need tsvectortsvector
only because of language support for lexemization"lexemization". Actually, I just need to leximizeconvert text, e.g.:
select array_to_string(tsvector_to_array(to_tsvector('english', 'I just want to lexemize this string and keep the original order of lexemes...')), ' ');
This gives me leximized text which is OK, except lexemes are ordered alphabetically instead of their original relative order in original text...