[postgis-users] Issue with the geometry field in postgresql tables

Vincent J. Troisi Vincent.Troisi at Colorado.EDU
Tue Dec 19 07:51:05 PST 2006

Any examples of how one might implement functional indices on 
transformed geometries?


Markus Schaber wrote:
> Hi, Paul,
> Paul Ramsey <pramsey at refractions.net> wrote:
>> Sure, just drop the constraints and go crazy.  Mixed geometry types  
>> should not present any troubles at all, for either the functions or  
>> the indexes.  Mixed SRIDs will break all kinds of things unless you  
>> wrap everything in a transform() to force everything into a common  
>> plane at operation time.  Indexing in particular will not work on  
>> mixed SRIDs.
> However, it's possible to create functional indices on transformed
> geometries.
> Regards,
> Markus

More information about the postgis-users mailing list