proximity

I'm using postgresql to calculate if different points are inside a specific range (calculated using pythagoras). The thing is that I would like to get the results ordered by the proximity instead of randomly. This is my query: select *…