问题:

We have a point (x,y) and a set of some other points (xi,yi). How can we determine which of (xi,yi) are within a circle with center (x,y) and radius r (a given number)?

回答1:

(xi-x)**2 + (yi-y)**2 < r**2

回答2:

Simple way.

Compute the distance from the point to the center of the circle. If less than radius , then its within the circle.

回答3:

If (xi - x)^2 + (yi - y)^2 is less than d^2, it's inside. If it equals d^2, it's on the circle. If it's greater than d^2, it's outside.

回答4:

If sqrt((xi-x)^2 + (yi-y)^2) <= d

回答5:

I had the same problem to solve inside a plsql procedure. The solution above are completely right and I did the same. But it compromised the performance of my plsql program drastically. Instead of that circle calculation, I used a square. Because it can be done without doing such calculation and in the sql statement itself. It improved the query performance by more than 10x