Hi,
I've the following table,and has created the index on uid and location;
CREATE TABLE points
(
location geometry, //assume it's a 2-dimension point
uid integer
)
Now, I've a point P with uid= 12345, and want to find the neighbors which
are within 20, how to write the sql?Is this right?
Hi Sunpeng,
Definitely use ST_DWithin.
-Francis
On 13 September 2010 06:51, sunpeng blueva...@gmail.com wrote:
Hi,
I've the following table,and has created the index on uid and location;
CREATE TABLE points
(
location geometry, //assume it's a 2-dimension point
uid integer
)
Now,