Hide Zen home . ... Function get_covers(tsvector,query) marks extents (from tsvector ), which satisfies the search query (extents could overlap). The markup is as follow: {# text }#, where # - is the extent number. ... Example: test=# select get_covers(to_tsvector('1 2 3 4 5 6 1 3 1 9 34 2'),'1&3'); get_covers --------------------------------------------------- {1 1 2 {2 3 }1 4 5 6 {3 1 }2 {4 3 }3 1 }4 9 34 2 (1 row) . ... First example could be obtained using get_covers(fts,query,0) . ...