I have several tables that have related data. I want to have a search input box on the dashboard of the system that will search for anything (client, invoice, delivery note, ...).
Is it possible to have a FTS implementation in PostgreSQL that will get the item searched for in more than one table and get the results?
For example, if the user typed 45, the query should look in the clients table and return the clients with id 45 or name has 45, also look in the invoices table and return the invoices with number 45, and also look into the delivery notes table and return the delivery notes with number 45.
Or is there a better way of solving this problem without using full text search?
45
,123456
,45fingers
,1945
,killed 45 people
. If it's not just digits: also case insensitive? Even fuzzy? Then you need to define the return type and the sort order exactly. – Erwin Brandstetter Jun 24 '13 at 20:06