Sample Header Ad - 728x90

PostgreSQL full text search on many columns

12 votes
2 answers
22485 views
I need an advice with searching of record based on specified string. Search strings can contain values from these columns. Values in this string don´t have to be strictly identical given in the correct order and also the values of some columns in this string may be missing. Example of search string: 22 Karntner Wien And I get for example result with top 5 similar records. I think I should use full text search, but I have no experiences with it. Can you tell me how to proceed?
Asked by Denis Stephanov (287 rep)
Feb 11, 2017, 01:06 PM
Last activity: Dec 31, 2023, 06:17 AM