1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
--
-- pg_similarity
-- testing similarity variables
--
--
-- Clean up in case a prior regression run failed
--
RESET client_min_messages;
\set ECHO all
LOAD 'pg_similarity';
--
-- errors
--
SHOW pg_similarity.foo_tokenizer;
SHOW pg_similarity.foo_is_normalized;
SET pg_similarity.cosine_threshold to 1.1;
SET pg_similarity.qgram_tokenizer to 'alnum';
SHOW pg_similarity.jaro_tokenizer;
--
-- valid values
--
SET pg_similarity.block_is_normalized to true;
SET pg_similarity.cosine_threshold = 0.72;
SET pg_similarity.dice_tokenizer to 'alnum';
SET pg_similarity.euclidean_is_normalized to false;
SET pg_similarity.jaro_winkler_is_normalized to false;
SET pg_similarity.qgram_tokenizer to 'gram';
|
