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

[Vincent J. Troisi]

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

Vince

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
>
>