|varbit|_varbit_aa_ops|_varbit_aa_ops|_varbit_aa_ops|

|varchar|_varchar_aa_ops|_varchar_aa_ops|_varchar_aa_ops|

Operator class names implemented for back compatibility with RUM versions 1.2 and 1.3

All anyarray support moved from RUM extension to AnyArray extension since RUM version 1.4 . Operator class names`aa_rum_anyarray_ops` and`aa_rum_anyarray_addon_ops` are implemented in AnyArray.

CREATEINDEXidx_test_int4ON test_int4 USING rum (v aa_rum_anyarray_ops);

SET enable_seqscan=off;

EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v &&'{43,50}'ORDER BY t;

EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v @>'{43,50}'ORDER BY t;

EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v<@'{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v='{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

EXPLAIN (COSTS OFF)SELECT t, vFROM test_int4WHERE v %'{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

SELECT t, vFROM test_int4WHERE v &&'{43,50}'ORDER BY t;

SELECT t, vFROM test_int4WHERE v @>'{43,50}'ORDER BY t;

SELECT t, vFROM test_int4WHERE v<@'{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

SELECT t, vFROM test_int4WHERE v='{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

SETanyarray.similarity_type=cosine;

SELECT t, vFROM test_int4WHERE v %'{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

SETanyarray.similarity_type=jaccard;

SELECT t, vFROM test_int4WHERE v %'{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

SETanyarray.similarity_type=overlap;

SETanyarray.similarity_threshold=3;

SELECT t, vFROM test_int4WHERE v %'{0,1,2,3,4,5,6,7,8,9,10}'ORDER BY t;

RESETanyarray.similarity_threshold;

CREATETABLEtest_array (

i int2[]

);

INSERT INTO test_arrayVALUES ('{}'), ('{0}'), ('{1,2,3,4}'), ('{1,2,3}'), ('{1,2}'), ('{1}');

ALTERTABLE test_array ADD COLUMN add_infotimestamp;

WITH qas (

SELECT row_number() OVER (ORDER BY i) idx, ctidFROM test_array

)

UPDATE test_arraySET add_info='2016-05-16 14:21:25'::timestamp+

format('%s days',q.idx)::interval

FROM qWHEREtest_array.ctid=q.ctid;

CREATEINDEXidx_arrayON test_array

USING rum (i aa_rum_anyarray_addon_ops, add_info)

WITH (attach='add_info', to='i');

SELECT*FROM test_arrayWHERE i &&'{1}'ORDER BY add_info<=>'2016-05-16 14:21:25'LIMIT10;

Install the latest version and run in every database you want to upgrade: