Home
last modified time | relevance | path

Searched refs:gist_tbl (Results 1 – 25 of 86) sorted by relevance

1234

/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql14-server/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql14-plpython/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql14-docs/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql14-client/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql14-contrib/postgresql-14.1/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/
H A Dgist.sql44 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);
103 create index gist_tbl_box_index on gist_tbl using gist (b);
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))
135 select p, c from gist_tbl
139 select b, p from gist_tbl
[all …]
/dports/databases/postgresql96-server/postgresql-9.6.24/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql96-pltcl/postgresql-9.6.24/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql96-plperl/postgresql-9.6.24/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql96-plpython/postgresql-9.6.24/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-plperl/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-docs/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-contrib/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-client/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-plpython/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-pltcl/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]
/dports/databases/postgresql10-server/postgresql-10.19/src/test/regress/sql/
H A Dgist.sql32 create table gist_tbl (b box, p point, c circle); table
34 insert into gist_tbl
40 vacuum analyze gist_tbl;
47 create index gist_tbl_point_index on gist_tbl using gist (p);
91 create index gist_tbl_box_index on gist_tbl using gist (b);
95 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
98 select b from gist_tbl where b <@ box(point(5,5), point(6,6));
104 create index gist_tbl_multi_index on gist_tbl using gist (p, c);
107 select p, c from gist_tbl
111 select b, p from gist_tbl
[all …]

1234