80
80
FROM POINT_TBL p1, POINT_TBL p2
81
81
WHERE (p1.f1 <-> p2.f1) > 3 and p1.f1 << p2.f1 and p1.f1 >^ p2.f1
84
-- Test that GiST indexes provide same behavior as sequential scan
85
CREATE TEMP TABLE point_gist_tbl(f1 point);
86
INSERT INTO point_gist_tbl SELECT '(0,0)' FROM generate_series(0,1000);
87
CREATE INDEX point_gist_tbl_index ON point_gist_tbl USING gist (f1);
88
INSERT INTO point_gist_tbl VALUES ('(0.0000009,0.0000009)');
89
SET enable_seqscan TO true;
90
SET enable_indexscan TO false;
91
SET enable_bitmapscan TO false;
92
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000009,0.0000009)'::point;
93
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 <@ '(0.0000009,0.0000009),(0.0000009,0.0000009)'::box;
94
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000018,0.0000018)'::point;
95
SET enable_seqscan TO false;
96
SET enable_indexscan TO true;
97
SET enable_bitmapscan TO true;
98
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000009,0.0000009)'::point;
99
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 <@ '(0.0000009,0.0000009),(0.0000009,0.0000009)'::box;
100
SELECT COUNT(*) FROM point_gist_tbl WHERE f1 ~= '(0.0000018,0.0000018)'::point;
101
RESET enable_seqscan;
102
RESET enable_indexscan;
103
RESET enable_bitmapscan;