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