1 set extra_float_digits =0;
2 SELECT set_smlar_limit(0.8);
4 DROP INDEX idx_test_int8;
6 SELECT smlar('{199,199,199,199,1}', '{199,1}'::int8[]);
7 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_int8 WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
8 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_int8 WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
10 CREATE INDEX idx_test_int8 ON test_int8 USING gist (v _int8_sml_ops);
11 SET enable_seqscan = off;
13 SELECT smlar('{199,199,199,199,1}', '{199,1}'::int8[]);
14 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_int8 WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
15 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_int8 WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;
18 DROP INDEX idx_test_int8;
20 CREATE INDEX idx_test_int8 ON test_int8 USING gin (v _int8_sml_ops);
21 SET enable_seqscan = off;
23 SELECT smlar('{199,199,199,199,1}', '{199,1}'::int8[]);
24 SELECT t, smlar(v, '{10,9,8,7,6,5,4,3,2,1}') AS s FROM test_int8 WHERE v % '{10,9,8,7,6,5,4,3,2,1}' ORDER BY s DESC, t;
25 SELECT t, smlar(v, '{50,49,8,7,6,5,4,33,2,1}') AS s FROM test_int8 WHERE v % '{50,49,8,7,6,5,4,33,2,1}' ORDER BY s DESC, t;