1

2 CREATE EXTENSION latlon;

3

4 CREATE TABLE "test" (

5 "id" SERIAL4 PRIMARY KEY,

6 "location" EPOINT NOT NULL,

7 "surrounding" ECIRCLE NOT NULL,

8 "multipoint" ECLUSTER NOT NULL,

9 "triangle" ECLUSTER NOT NULL );

10

11 CREATE INDEX "test_location_key" ON "test" USING gist ("location");

12 CREATE INDEX "test_surrounding_key" ON "test" USING gist ("surrounding");

13 CREATE INDEX "test_multipoint_key" ON "test" USING gist ("multipoint");

14 CREATE INDEX "test_triangle_key" ON "test" USING gist ("triangle");

15