explain (costs off)

SELECT * FROM test_rum WHERE a @@ to_tsquery('pg_catalog.english', 'ever|wrote')

ORDER BY a>< to_tsquery('pg_catalog.english', 'ever|wrote');

ORDER BY a<-> to_tsquery('pg_catalog.english', 'ever|wrote');

QUERY PLAN

------------------------------------------------------------------

Sort

Sort Key: ((a>< '''ever'' | ''wrote'''::tsquery))

Sort Key: ((a<-> '''ever'' | ''wrote'''::tsquery))

-> Bitmap Heap Scan on test_rum

Recheck Cond: (a @@ '''ever'' | ''wrote'''::tsquery)

-> Bitmap Index Scan on rumidx

SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way')), *

FROM test_rum

WHERE a @@ to_tsquery('pg_catalog.english', 'way')

ORDER BY a>< to_tsquery('pg_catalog.english', 'way');

ORDER BY a<-> to_tsquery('pg_catalog.english', 'way');

rum_ts_distance | t | a

-----------------+--------------------------------------------------------------------------+---------------------------------------------------------------

0.0607927 | my appreciation of you in a more complimentary way than by sending this | 'appreci':2 'complimentari':8 'send':12 'way':9

SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english', 'way & (go | half)')), *

FROM test_rum

WHERE a @@ to_tsquery('pg_catalog.english', 'way & (go | half)')

ORDER BY a>< to_tsquery('pg_catalog.english', 'way & (go | half)');

ORDER BY a<-> to_tsquery('pg_catalog.english', 'way & (go | half)');

rum_ts_distance | t | a

-----------------+---------------------------------------------------------------------+---------------------------------------------------------

0.103556 | 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

LANGUAGE C IMMUTABLE STRICT;

CREATE OPERATOR>< (

CREATE OPERATOR<-> (

LEFTARG= tsvector,

RIGHTARG= tsquery,

PROCEDURE= rum_ts_distance,

COMMUTATOR='><'

PROCEDURE= rum_ts_distance

);

CREATEFUNCTIONrum_extract_tsvector(tsvector,internal,internal,internal,internal)

FOR TYPE tsvector USING rum

OPERATOR1 @@ (tsvector, tsquery),

OPERATOR2>< (tsvector, tsquery) FORORDER BYpg_catalog.float_ops,

OPERATOR2<-> (tsvector, tsquery) FORORDER BYpg_catalog.float_ops,

FUNCTION1 gin_cmp_tslexeme(text,text),

FUNCTION2 rum_extract_tsvector(tsvector,internal,internal,internal,internal),

FUNCTION3 rum_extract_tsquery(tsquery,internal,smallint,internal,internal,internal,internal),

SELECTcount(*)FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english','ever|wrote');

explain (costs off)

SELECT*FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english','ever|wrote')

ORDER BY a>< to_tsquery('pg_catalog.english','ever|wrote');

ORDER BY a<-> to_tsquery('pg_catalog.english','ever|wrote');

explain (costs off)

SELECTcount(*)FROM test_rumWHERE a @@ to_tsquery('pg_catalog.english',

'def <-> fgr');

SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english','way')),*

FROM test_rum

WHERE a @@ to_tsquery('pg_catalog.english','way')

ORDER BY a>< to_tsquery('pg_catalog.english','way');

ORDER BY a<-> to_tsquery('pg_catalog.english','way');

SELECT rum_ts_distance(a, to_tsquery('pg_catalog.english','way & (go | half)')),*

FROM test_rum

WHERE a @@ to_tsquery('pg_catalog.english','way & (go | half)')

ORDER BY a>< to_tsquery('pg_catalog.english','way & (go | half)');

ORDER BY a<-> to_tsquery('pg_catalog.english','way & (go | half)');

INSERT INTO test_rum (t)VALUES ('foo bar foo the over foo qq bar');

INSERT INTO test_rum (t)VALUES ('345 qwerty copyright');