annotate create_test_db.schema.sql @ 16:e319679cefbd
Added more operators for clusters (including polygons); Bugfix regarding missing entries in ecluster_ops operator class (index was not used for nearest-neighbor searches)
| author |
jbe |
| date |
Fri Sep 09 19:22:30 2016 +0200 (2016-09-09) |
| parents |
684a78d2f9f0 |
| children |
3cbce515387f |
| rev |
line source |
|
jbe@0
|
1
|
|
jbe@0
|
2 CREATE EXTENSION latlon;
|
|
jbe@0
|
3
|
|
jbe@0
|
4 CREATE TABLE "test" (
|
|
jbe@0
|
5 "id" SERIAL4 PRIMARY KEY,
|
|
jbe@0
|
6 "location" EPOINT NOT NULL,
|
|
jbe@10
|
7 "surrounding" ECIRCLE NOT NULL,
|
|
jbe@10
|
8 "multipoint" ECLUSTER NOT NULL,
|
|
jbe@10
|
9 "triangle" ECLUSTER NOT NULL );
|
|
jbe@0
|
10
|
|
jbe@10
|
11 CREATE INDEX "test_location_key" ON "test" USING gist ("location");
|
|
jbe@10
|
12 CREATE INDEX "test_surrounding_key" ON "test" USING gist ("surrounding");
|
|
jbe@10
|
13 CREATE INDEX "test_multipoint_key" ON "test" USING gist ("multipoint");
|
|
jbe@10
|
14 CREATE INDEX "test_triangle_key" ON "test" USING gist ("triangle");
|
|
jbe@0
|
15
|