rum

pig build pkg rum;		# build rpm

pig repo add pgsql -u   # add both repo and update cache

pig install rum;		# install via package name, for the active PG version

pig install rum -v 18;   # install for PG 18
pig install rum -v 17;   # install for PG 17
pig install rum -v 16;   # install for PG 16
pig install rum -v 15;   # install for PG 15
pig install rum -v 14;   # install for PG 14

CREATE EXTENSION rum;

CREATE INDEX idx ON table_name USING rum (column operator_class);

CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d)
    WITH (attach = 'd', to = 't');

SELECT t, a <=> to_tsquery('english', 'beautiful | place') AS rank
FROM test_rum
WHERE a @@ to_tsquery('english', 'beautiful | place')
ORDER BY a <=> to_tsquery('english', 'beautiful | place');

SELECT id, d, d <=> '2016-05-16 14:21:25' FROM tsts
WHERE t @@ 'wr&qh'
ORDER BY d <=> '2016-05-16 14:21:25'
LIMIT 5;

SELECT * FROM test_array
WHERE i && '{1}'
ORDER BY i <=> '{1}' ASC;