regress/sql/gist.sql

44 create table gist_tbl (b box, p point, c circle);
46 insert into gist_tbl
52 vacuum analyze gist_tbl;
59 create index gist_tbl_point_index on gist_tbl using gist (p);
63 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5));
66 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5));
70 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
73 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
78 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
81 select p from gist_tbl where p <@ box(point(0,0), point(0.5, 0.5))
91   (select p from gist_tbl where p <@ bb order by p <-> bb[0] limit 2) ss;
98   (select p from gist_tbl where p <@ bb order by p <-> bb[0] limit 2) ss;
103 create index gist_tbl_box_index on gist_tbl using gist (b);
107 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
110 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
114 select b from gist_tbl where b <@ box(point(5,5), point(6,6))
117 select b from gist_tbl where b <@ box(point(5,5), point(6,6))
122 select b from gist_tbl where b <@ box(point(5,5), point(6,6))
125 select b from gist_tbl where b <@ box(point(5,5), point(6,6))
132 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
135 select p, c from gist_tbl
139 select b, p from gist_tbl
150 drop table gist_tbl;