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