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

[Mark Cave-Ayland]

Markus Schaber wrote:
> Hi, David,
> 
> "David William Bitner" <david.bitner at gmail.com> wrote:
> 
>> I'm not actually doing this, but I helped someone else on IRC set this up a
>> while ago because the overlaps operator for time does not make use of any
>> indexes on time data types.  The solution that he used was to create 1-d
>> lines (ie 0 1,0 5) that represented a time period so he could just use &&
>> for an indexed overlaps operator.  A little hacky, but it seemed to work
>> quite well for him.
> 
> Then the way to go would be to fix the time data types.
> 
> Regards,
> Markus

I guess so. I don't know whether SQL OVERLAPS() will use the indexes, 
however the standard GiST R-Tree && operator should do without any problems.


ATB,

Mark.

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