[postgis-users] 3D index in postgis

[a1001800]

Hi,

Please see the sql SELECT id, AsText(map_geom) AS geom FROM maps where ST_Equals(map_geom,GeomFromText('POINT(3 3 1)', -1));
And it matches point(3 3 1), point(3 3 2), point(3 3 3) ...

The geo field and index is below:

SELECT AddGeometryColumn( 'maps', 'map_geom', -1, 'GEOMETRY', 3);
CREATE INDEX geomk ON maps USING GIST (map_geom);

So it looks like that the index is only working in 2D

How can I build a index on the 3rd coordinate？

Thanks
Frank
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080518/b83be060/attachment.html>