Can we save the complete name with spaces as one of the tsvs. For example, if I have 'Test 6' as the name, can I save 'test', 'test 6' as text search vectors.
I am currently running into issues with search on postgres where the search is done on text search vectors(tsv).
Use Case: I have a column 'groupName' which is converted into text search vectors(tsv) and saved, and then all my search requests goes against those tsv's. To overcome a certain use case we are stripping off the last digit from the group name. For example if the group name is 'Test 6', we strip off 6 and save only 'test' in tsv. The 'groupName' column as such will still have the complete name with the digit. Now the issue it creates it if we do a search on exact match ('Test 6' in this case), it will not be returned in the result, but I do search only for 'Test', the result will have 'Test 6' also.
Can we save the complete name with spaces as one of the tsvs.