pgLatLon

diff create_test_db.schema.sql @ 10:684a78d2f9f0
Introduced lossy overlap operator (&&+) and fixed ecircle overlap searches on GiST-indexed ecluster columns
author: jbe
date: Fri Sep 02 14:08:01 2016 +0200 (2016-09-02)
parents: 3b70e93cc07d
children: 3cbce515387f
     1.1 --- a/create_test_db.schema.sql	Fri Sep 02 14:04:04 2016 +0200
     1.2 +++ b/create_test_db.schema.sql	Fri Sep 02 14:08:01 2016 +0200
     1.3 @@ -4,8 +4,12 @@
     1.4  CREATE TABLE "test" (
     1.5          "id"            SERIAL4         PRIMARY KEY,
     1.6          "location"      EPOINT          NOT NULL,
     1.7 -        "area"          ECIRCLE         NOT NULL );
     1.8 +        "surrounding"   ECIRCLE         NOT NULL,
     1.9 +        "multipoint"    ECLUSTER        NOT NULL,
    1.10 +        "triangle"      ECLUSTER        NOT NULL );
    1.11  
    1.12 -CREATE INDEX "test_location_key" ON "test" USING gist ("location");
    1.13 -CREATE INDEX "test_area_key"     ON "test" USING gist ("area");
    1.14 +CREATE INDEX "test_location_key"    ON "test" USING gist ("location");
    1.15 +CREATE INDEX "test_surrounding_key" ON "test" USING gist ("surrounding");
    1.16 +CREATE INDEX "test_multipoint_key"  ON "test" USING gist ("multipoint");
    1.17 +CREATE INDEX "test_triangle_key"    ON "test" USING gist ("triangle");
    1.18