liquid_feedback_core: 96ee2db56bec pgLatLon/create_test

liquid_feedback_core

New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback

line source

2 CREATE EXTENSION latlon;

4 CREATE TABLE "test" (

5 "id" SERIAL4 PRIMARY KEY,

6 "location" EPOINT NOT NULL,

7 "area" ECIRCLE NOT NULL );

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

10 CREATE INDEX "test_area_key" ON "test" USING gist ("area");