1 SELECT set_smlar_limit(0.3);
7 SET smlar.type = "tfidf";
8 SET smlar.stattable = "interval_stat";
9 UPDATE test_interval SET v = v || '{50,50,50}'::interval[] WHERE t >=50 AND t < 60;
10 INSERT INTO test_interval VALUES(201, '{50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50,50}');
11 CREATE TABLE interval_stat (
12 value interval UNIQUE,
13 ndoc int4 NOT NULL CHECK (ndoc>0)
15 NOTICE: CREATE TABLE / UNIQUE will create implicit index "interval_stat_value_key" for table "interval_stat"
16 INSERT INTO interval_stat (
21 (SELECT array_to_col(v) AS w FROM test_interval WHERE v IS NOT NULL) AS q
24 INSERT INTO interval_stat VALUES (NULL, (SELECT count(*) FROM test_interval));
25 DROP INDEX idx_test_interval;
26 SET smlar.tf_method = "n";
27 SET smlar.idf_plus_one = off;
28 SELECT smlar('{199,199,199,199,1}', '{199,1}'::interval[]);
34 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
72 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
256 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
294 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
478 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
516 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
692 CREATE INDEX idx_test_interval ON test_interval USING gist (v _interval_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}'::interval[]);
702 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
740 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
924 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
962 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1146 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1184 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1360 DROP INDEX idx_test_interval;
1361 CREATE INDEX idx_test_interval ON test_interval USING gin (v _interval_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}'::interval[]);
1371 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1383 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1395 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1407 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1419 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval 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}'::interval[]);
1457 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_interval 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_interval WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
1633 RESET enable_seqscan;