@@ -112,14 +112,17 @@ SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way & (go | half)'))
112
112
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
113
113
(2 rows)
114
114
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
+ *
116
119
FROM test_rum
117
120
ORDER 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
123
126
(3 rows)
124
127
125
128
INSERT INTO test_rum (t) VALUES ('foo bar foo the over foo qq bar');
0 commit comments