[postgis-devel] Re: [postgis-users] create tables smarter

[Mark Cave-Ayland]

David William Bitner wrote:
> One use in adding 1-dimension support would be to make it easier for folks
> who are using postgis for non-spatial utility for using the GIST indexing.
> For example there are some people throwing time as a unix epoch into PostGIS
> in order to do efficient time period overlaps queries.

Errr... this may be a silly question, but why are they not using 
PostgreSQL's in-built (and more recently GiST-based) R-Tree index if 
they are indexing non-geometry fields in this way?


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063