5 ms·DISTINCT ON is also very useful for nearest neighbor queries with PostGIS.by thibautg 7y agoDISTINCT ON is also very useful for nearest neighbor queries with PostGIS.