liquid_feedback_core

diff pgLatLon/create_test_db.data.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)
parents
children
line diff
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/pgLatLon/create_test_db.data.sql	Thu Aug 18 20:19:58 2016 +0200
     1.3 @@ -0,0 +1,6 @@
     1.4 +
     1.5 +INSERT INTO "test" ("location", "area") SELECT
     1.6 +  epoint((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180),
     1.7 +  ecircle((asin(2*random()-1) / pi()) * 180, (2*random()-1) * 180, -ln(1-random()) * 1000)
     1.8 +  FROM generate_series(1, 10000);
     1.9 +

Impressum / About Us