I want to a text search with two words as a single word. For Eg. Business Analyst. When I convert this into ts_query it convert into ‘Business & Analyst’ but it brings up the result as either business as one word matches and analyst with second matches.
Please let me know whether I need to any other addition in ts_query or ts_vector