Set threshold for similarity search. Default value is 0.6 . RESET value is 0.0 . anyarray.similarity_threshold accept values from 0.0 to 1e10 .

Set threshold for similarity search. Default value is 0.6 . RESET value is 0.0 .`anyarray.similarity_threshold` accept values from 0.0 to 1e10 .

RUM version 1.2 and 1.3 used variables rum.array_similarity_function and rum.array_similarity_threshold that are obsolete and replaced by anyarray.similarity_type and anyarray.similarity_threshold.

RUM version 1.2 and 1.3 used variables`rum.array_similarity_function` and`rum.array_similarity_threshold` that are obsolete and replaced by`anyarray.similarity_type` and`anyarray.similarity_threshold`.

Examples

Examples for INTEGER[] .

SELECT t, ARRAY(

SELECT v::int4

FROM generate_series(GREATEST(0, t-10), t)as v

)AS v

INTO test_int4

FROM generate_series(1,200)as t;

SETanyarray.similarity_type=cosine;

SELECT t, similarity(v,'{10,9,8,7,6,5,4,3,2,1}')AS sFROM test_int4

WHERE v %'{10,9,8,7,6,5,4,3,2,1}'ORDER BY sDESC, t;

CREATEINDEXidx_test_int4ON test_int4 USING gist (v _int4_aa_ops);

SET enable_seqscan=off;

CREATEINDEXidx_test_int4ON test_int4 USING gin (v _int4_aa_ops);

SET enable_seqscan=off;

CREATEINDEXidx_test_int4ON test_int4 USING rum (v _int4_aa_ops);

SET enable_seqscan=off;

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

ALTER EXTENSION anyarrayUPDATE;

You need to close this database server connection to apply changes.