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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 4 of 10 | next ›
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedJan 8, '13 at 3:21p
activeJan 11, '13 at 10:22p
posts10
users6
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase