@@ -112,14 +112,17 @@ SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way & (go | half)'))
112112 10.0905 | itself. Put on your “specs” and look at the castle, half way up the | 'castl':10 'half':11 'look':7 'put':2 'spec':5 'way':12
113113(2 rows)
114114
115- SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way & (go | half)')), *
115+ SELECT
116+ a <-> to_tsquery('pg_catalog.english', 'way & (go | half)'),
117+ rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way & (go | half)')),
118+ *
116119FROM test_rum
117120ORDER BY a <-> to_tsquery('pg_catalog.english', 'way & (go | half)') limit 3;
118- rum_ts_distance | t | a
119- -----------------+-------------------------------------------------------------------------+---------------------------------------------------------
120- 9.65659 | thinking--“to go or not to go?” We are this far on the way. Reached | 'far':11 'go':3,7 'reach':15 'think':1 'way':14
121- 10.0905 | itself. Put on your “specs” and look at the castle, half way up the | 'castl':10 'half':11 'look':7 'put':2 'spec':5 'way':12
122- 1e+20 | my appreciation of you in a more complimentary way than by sending this | 'appreci':2 'complimentari':8 'send':12 'way':9
121+ ?column? | rum_ts_distance | t | a
122+ ----------+---------- -------+-------------------------------------------------------------------------+---------------------------------------------------------
123+ 9.65659 | 9.65659 | thinking--“to go or not to go?” We are this far on the way. Reached | 'far':11 'go':3,7 'reach':15 'think':1 'way':14
124+ 10.0905 | 10.0905 | itself. Put on your “specs” and look at the castle, half way up the | 'castl':10 'half':11 'look':7 'put':2 'spec':5 'way':12
125+ 1e+20 | 1e+20 | my appreciation of you in a more complimentary way than by sending this | 'appreci':2 'complimentari':8 'send':12 'way':9
123126(3 rows)
124127
125128INSERT INTO test_rum (t) VALUES ('foo bar foo the over foo qq bar');