Until version 9, Chinese full-text search is not shipped with PostgreSQL official release, and has to be implement by third-party extensions. Zhparser, based on Xunsearch's Simple Chinese Word ...
Supposed soluctions are: Make '地球上' a token with higher priority than '上海'(bad idea); Make '海陆' a token with higher priority than '上海'; Use in table and querys Note: I have added my custom dict for ...