liquid_feedback_core

diff pgLatLon/create_test_db.schema.sql @ 529:96ee2db56bec
New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback
author: jbe
date: Thu Aug 18 20:19:58 2016 +0200 (2016-08-18)
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/pgLatLon/create_test_db.schema.sql	Thu Aug 18 20:19:58 2016 +0200
     1.3 @@ -0,0 +1,11 @@
     1.4 +
     1.5 +CREATE EXTENSION latlon;
     1.6 +
     1.7 +CREATE TABLE "test" (
     1.8 +        "id"            SERIAL4         PRIMARY KEY,
     1.9 +        "location"      EPOINT          NOT NULL,
    1.10 +        "area"          ECIRCLE         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 +