<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18975"></meta>
</head>
<body>
<div align="left">Your syntax is a little backwards an it is better to use st_dwithin instead:</div>
<div align="left"> </div>
<div align="left">select gid, the_geom, floorarea from "building" as m where ST_DWithin(m.geom,'POINT<span style="FONT-FAMILY: Courier New">(306404701,6755737)'::geometry, 200.0</span>);<br />
</div>
<div align="left">HTH</div>
<div align="left">Nicklas<br />
<br />
2010-10-19 zhang zhe wrote:<br />
<br />
Hello,<br />
> <br />
> I have one table called building.sql which contains points. I want to select building which fall within a circle. This circle is not a sql table but instead only coordinate and radius such as <span style="FONT-FAMILY: Courier New">circle(point '(0,0)', 2.0)</span>. <br />
> <br />
> My sql query is like this <br />
> select gid, the_geom, floorarea from "building" as m where m.geom within(GeoFromText(<span style="FONT-FAMILY: Courier New">circle(point '(306404701,6755737)', 200.0))</span>);<br />
> <br />
> But it gives me erro. Does anyone knows where went wrong? <br />
> <br />
> Thanks a lot<br />
> <br />
> </div>
</body>
</html>