Postgresql full text search to_tsvector() function returns a sorted array of lexemes. I need exactly the same function, but returning unsorted array of lexemes. Is there any such postgresql function already available or I need to do it myself? How to do it?
I need it for Jaro-Winkler string similarity function, for which order of strings/words is important...I need tsvector only because of language support for lexemization. Actually, I just need to leximize 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 their original relative order in original text...