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
32
33
34
35
36
37
38
39
40
41
|
--
-- pg_similarity
-- testing similarity variables
--
--
-- Clean up in case a prior regression run failed
--
RESET client_min_messages;
\set ECHO all
\set a '\'Euler Taveira de Oliveira\''
CREATE TABLE simtst (a text);
INSERT INTO simtst (a) VALUES
('Euler Taveira de Oliveira'),
('EULER TAVEIRA DE OLIVEIRA'),
('Euler T. de Oliveira'),
('Oliveira, Euler T.'),
('Euler Oliveira'),
('Euler Taveira'),
('EULER TAVEIRA OLIVEIRA'),
('Oliveira, Euler'),
('Oliveira, E. T.'),
('ETO');
\copy simtst FROM 'data/similarity.data'
SELECT a, block(a, :a) FROM simtst WHERE a ~++ :a;
SELECT a, cosine(a, :a) FROM simtst WHERE a ~## :a;
CREATE INDEX simtsti ON simtst USING gin (a gin_similarity_ops);
SELECT a, block(a, :a) FROM simtst WHERE a ~++ :a;
SET enable_bitmapscan TO OFF;
SELECT a, block(a, :a) FROM simtst WHERE a ~++ :a;
SET enable_bitmapscan TO ON;
SELECT a, cosine(a, :a) FROM simtst WHERE a ~## :a;
DROP TABLE simtst;
|
