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

[David William Bitner]

I could care less.  I was just pointing out a way that PostGIS *is* getting
used, whether being used as intended or not.

On Fri, Jun 6, 2008 at 11:27 AM, Chris Hodgson <chodgson at refractions.net>
wrote:

>
>
>>> Then the way to go would be to fix the time data types.
>>>
>>>
>> 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.
>>
>>  Alternatively there is the cube extension, which works well for this
> purpose (but can create large indexes, at least when used for many
> dimensions).
>
> Regardless, I would venture to say that is not a goal of PostGIS to support
> this usage. Users doing this will be able to continue using the same hack,
> by storing single-dimension objects in multi-dimensional fields. It will
> waste some space, but that is their fault for not making use of the
> appropriate alternatives.
>
> Chris
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20080606/7295ac80/attachment.html>