... country name . ... Query " Moscow's celebrations hotel Moscow, Russia" would failed if search attributes separately, but could be succeeded if search their concatenation. ... hotel". ... Simple search for "Moscow": # select name, country, place, rank( idx, ftsquery ) as r from hotels, to_tsquery('Moscow') as ftsquery where idx @@ ftsquery order by r desc; name | ... Query "Moscow hotel" (rewritten by hand): # select name, country, place, rank( idx, ftsquery ) as r from hotels, to_tsquery('Moscow | ...