sql - Postgres/postgis. Find all points so that no two points are within X units of each other

Question

I have a sql table containing approx 46,000 rows of Zipcode and its center lat/lng for cities in the US.

I am wanting to run a query where the resulting set contains a table of points however, all points are at least X units away. Basically am able to map an area where no two circles (a lat/lng with a radius of X units) intersect.

question from:https://stackoverflow.com/questions/65891932/postgres-postgis-find-all-points-so-that-no-two-points-are-within-x-units-of-ea

Answer 1

Waitting for answers