1 SELECT set_smlar_limit(0.3);
7 SET smlar.type = "tfidf";
8 SET smlar.stattable = "text_stat";
9 UPDATE test_text SET v = v || '{50,50,50}'::text[] WHERE t >=50 AND t < 60;
10 INSERT INTO test_text VALUES(201, '{50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50}');
11 CREATE TABLE text_stat (
13 ndoc int4 NOT NULL CHECK (ndoc>0)
15 NOTICE: CREATE TABLE / UNIQUE will create implicit index "text_stat_value_key" for table "text_stat"
16 INSERT INTO text_stat (
21 (SELECT array_to_col(v) AS w FROM test_text WHERE v IS NOT NULL) AS q
24 INSERT INTO text_stat VALUES (NULL, (SELECT count(*) FROM test_text));
25 DROP INDEX idx_test_text;
26 SET smlar.tf_method = "n";
27 SET smlar.idf_plus_one = off;
28 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
34 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
57 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
64 SET smlar.tf_method = "n";
65 SET smlar.idf_plus_one = on;
66 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
72 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
158 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
248 SET smlar.tf_method = "log";
249 SET smlar.idf_plus_one = off;
250 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
256 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
279 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
286 SET smlar.tf_method = "log";
287 SET smlar.idf_plus_one = on;
288 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
294 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
380 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
470 SET smlar.tf_method = "const";
471 SET smlar.idf_plus_one = off;
472 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
478 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
501 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
508 SET smlar.tf_method = "const";
509 SET smlar.idf_plus_one = on;
510 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
516 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
602 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
692 CREATE INDEX idx_test_text ON test_text USING gist (v _text_sml_ops);
693 SET enable_seqscan = off;
694 SET smlar.tf_method = "n";
695 SET smlar.idf_plus_one = off;
696 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
702 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
725 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
732 SET smlar.tf_method = "n";
733 SET smlar.idf_plus_one = on;
734 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
740 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
826 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
916 SET smlar.tf_method = "log";
917 SET smlar.idf_plus_one = off;
918 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
924 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
947 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
954 SET smlar.tf_method = "log";
955 SET smlar.idf_plus_one = on;
956 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
962 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1048 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1138 SET smlar.tf_method = "const";
1139 SET smlar.idf_plus_one = off;
1140 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1146 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1169 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1176 SET smlar.tf_method = "const";
1177 SET smlar.idf_plus_one = on;
1178 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1184 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1270 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1360 DROP INDEX idx_test_text;
1361 CREATE INDEX idx_test_text ON test_text USING gin (v _text_sml_ops);
1362 SET enable_seqscan = off;
1363 SET smlar.tf_method = "n";
1364 SET smlar.idf_plus_one = off;
1365 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1371 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1372 ERROR: GIN supports only smlar.tf_method = "const"
1373 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1374 ERROR: GIN supports only smlar.tf_method = "const"
1375 SET smlar.tf_method = "n";
1376 SET smlar.idf_plus_one = on;
1377 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1383 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1384 ERROR: GIN supports only smlar.tf_method = "const"
1385 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1386 ERROR: GIN supports only smlar.tf_method = "const"
1387 SET smlar.tf_method = "log";
1388 SET smlar.idf_plus_one = off;
1389 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1395 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1396 ERROR: GIN supports only smlar.tf_method = "const"
1397 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1398 ERROR: GIN supports only smlar.tf_method = "const"
1399 SET smlar.tf_method = "log";
1400 SET smlar.idf_plus_one = on;
1401 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1407 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1408 ERROR: GIN supports only smlar.tf_method = "const"
1409 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1410 ERROR: GIN supports only smlar.tf_method = "const"
1411 SET smlar.tf_method = "const";
1412 SET smlar.idf_plus_one = off;
1413 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1419 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1442 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1449 SET smlar.tf_method = "const";
1450 SET smlar.idf_plus_one = on;
1451 SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]);
1457 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_text WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
1543 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_text WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1633 RESET enable_seqscan;