<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=GB2312">
<META content="MSHTML 6.00.3790.3959" name=GENERATOR>
<STYLE>BLOCKQUOTE {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</STYLE>
</HEAD>
<BODY
style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px">
<DIV><FONT face=Verdana size=2>Hi,</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Please see the sql SELECT id, AsText(map_geom) AS
geom FROM maps where ST_Equals(map_geom,GeomFromText('POINT(3 3 1)',
-1));</FONT></DIV>
<DIV><FONT face=Verdana size=2>And it matches point(3 3 1), point(3 3 2),
point(3 3 3) ...</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>The geo field and index is below:</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>SELECT AddGeometryColumn( 'maps', 'map_geom', -1,
'GEOMETRY', 3);<BR></FONT><FONT face=Verdana size=2>CREATE INDEX geomk ON maps
USING GIST (map_geom);</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>So it looks like that the index is only working
in 2D</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>How can I build a index on the 3rd
coordinate£¿</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>Thanks</FONT></DIV>
<DIV><FONT face=Verdana size=2>Frank</FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV></BODY></HTML>