How to return latest results without a polygon intersect?

From: David Waddy <david(at)littleriver(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: How to return latest results without a polygon intersect?
Date: 2012-01-12 01:14:11
Message-ID: CAD3FPx90_G=-nBpvGwUbaG1GfmqiPbniJWcnP7rKis55ncFmig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I have a table of the following form:

id (integer) event_time (timestamp) lat_lon (polygon)
3497 1977-01-01 00:00:00
((-64.997,45.975),(,(-64.9981,45.975),(-64.8981,45.875),(-64.9978,45.9751))
3431 2007-06-06 01:00:00
((-64.971,45.982),(-64.921,45.982),(-64.972,45.982),(-64.973,45.98209),(-64.97,45.98237))
3498 1977-01-01 00:00:00
((-64.97838,45.9778),(-64.9783,45.97767),(-64.978,45.977),(-64.9781,45.97728),(-64.9781,45.97714),(-64.977,45.976))
...

How would I return a list of the latest events for a particular
lat/lon region? More precisely, how would a return a result set with
the greatest event times with polygons that don't intersect any other
polygon in the result set?

Any help would be greatly appreciated,
Dave

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edwin Quijada 2012-01-12 03:06:00 Compiling C function with VC++ for Windows version
Previous Message Kirill Müller 2012-01-12 01:08:27 Re: Enumeration of tables is very slow in largish database