1 set extra_float_digits =0;
2 SELECT set_smlar_limit(0.6);
14 generate_series(1, t) as v
18 generate_series(1, 200) as t;
19 SELECT t, smlar(v, '{3,2,1}') AS s FROM test_char WHERE v % '{3,2,1}' ORDER BY s DESC, t;
31 CREATE INDEX idx_test_char ON test_char USING gist (v _char_sml_ops);
32 SET enable_seqscan=off;
33 SELECT t, smlar(v, '{3,2,1}') AS s FROM test_char WHERE v % '{3,2,1}' ORDER BY s DESC, t;
45 DROP INDEX idx_test_char;
46 CREATE INDEX idx_test_char ON test_char USING gin (v _char_sml_ops);
47 SELECT t, smlar(v, '{3,2,1}') AS s FROM test_char WHERE v % '{3,2,1}' ORDER BY s DESC, t;
59 SET enable_seqscan=on;