From 00244817eaed7ae876b14d427d0d88587e5e807c Mon Sep 17 00:00:00 2001
From: =?utf8?q?=C3=98yvind=20A=2E=20Holm?= <sunny@sunbase.org>
Date: Mon, 8 Jul 2013 10:54:55 +0200
Subject: [PATCH] postgres/div.txt: Mention use of box

1dfaa100-e7ac-11e2-a4c2-001f3b596ec9
---
 postgres/div.txt | 4 ++++
 1 file changed, 4 insertions(+)

diff --git a/postgres/div.txt b/postgres/div.txt
index 80f4a6a..020e957 100644
--- a/postgres/div.txt
+++ b/postgres/div.txt
@@ -5,6 +5,10 @@ To list the closest track points from a coordinate:
 
 SELECT date, coor, name, dist, (point(60.30738,5.34574) <-> coor)::numeric AS avs FROM logg ORDER BY avs LIMIT 100;
 
+List all trackpoints inside a coordinate box:
+
+SELECT * from logg where box '((LAT1,LON1),(LAT2,LON2))' @> coor order by date;
+
 Time for updating:
 
 gps=# VACUUM ANALYZE ;
-- 
2.11.4.GIT