Stefan Keller wrote: > "... ORDER BY random() LIMIT 10;" works ok. > > But with the following option it gets more tricky assume: >> And as an option the (limited) resultset should be spatially >> distributed (not clustered). > > I'm thinking about some radial spatial distribution function. So, you explicitly *don't* want a random selection? By "spatially distributed" you mean that if you have already chosen one particular location, other locations which are close to it should be less probable (or impossible) to include in the limited result set? How would you define the desired result? The one with the highest best solution to the "traveling salesman" problem? -Kevin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
