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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
