How to select all points within a circle in PostGIS?

Sunday, 4 November 2018

I have set of points in a PostGIS Table (Type Geometry).

Now, I need to filter points that lie in a circle with a center (C) and radius (R)!

I expect C to be of type Point or Coordinates.. R to be in Meters!

SELECT * FROM my_points
    WHERE ST_Within(point, ...)

However, I don't know how to complete it..

How can I exactly measure C and R?

Blog