I have a postgis point table with a large list of cities.
I need to find duplicates in it, but only if they are 10km close each other, which means that is the same city.
For example, I have 5 points called 'Eneby', and suppose that 4 of this are 10Km close each others, and the 5th is 300Km...