Indexes in PostGIS are 2D only. In other words, an gist index on a 3D
geometry column will only use the first 2 dimensions of the geometries
(equal geometries in 2D, but varying in the 3rd dimension, are treated
the same).
Having said that, you probably can get 3D index support by way of the
PostgreSQL module cube.
http://www.postgresql.org/docs/8.3/static/cube.html
searchelite wrote:
Dear All, is there any 3d-index in postgis? how can i index a table that has
3d-coordinate values?
thanks
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users