1 set extra_float_digits =0;
2 SELECT set_smlar_limit(5.0);
3 SET smlar.type='overlap';
5 DROP INDEX idx_test_int8;
7 SELECT smlar('{199,199,199,199,1}', '{199,1}'::int8[]);
8 SELECT t, smlar(v, '{199,198,197,196,195,194,193,192,191,190}') AS s FROM test_int8 WHERE v % '{199,198,197,196,195,194,193,192,191,190}' ORDER BY s DESC, t;
10 CREATE INDEX idx_test_int8 ON test_int8 USING gin (v _int8_sml_ops);
11 SET enable_seqscan = off;
13 SELECT t, smlar(v, '{199,198,197,196,195,194,193,192,191,190}') AS s FROM test_int8 WHERE v % '{199,198,197,196,195,194,193,192,191,190}' ORDER BY s DESC, t;