Re: [postgis-users] Query with LIMIT but as random result set?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: [postgis-users] Query with LIMIT but as random result set?
Дата
Msg-id 20130110202824.255780@gmx.com
обсуждение исходный текст
Ответы Re: [postgis-users] Query with LIMIT but as random result set?  (Stefan Keller <sfkeller@gmail.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: When to run Vacuum in postgres 9.0.4
Следующее
От: Stefan Keller
Дата:
Сообщение: Re: [postgis-users] Query with LIMIT but as random result set?