nearest match

Поиск
Список
Период
Сортировка
От Ryan
Тема nearest match
Дата
Msg-id 10112.65.102.128.233.1047504752.squirrel@fordparts.com
обсуждение исходный текст
Список pgsql-sql
I'm doing some work with part diagrams and server-side image maps.
I want to store single point coordinates (x,y) for reference numbers in a
table looking like:

reference_number text,
x int,
y int

My question is:  How can I find the *nearest* match of some clicked on
coordinates without specifying some arbitrary distance from the stored
point?

The more I think about this the more I am realizing it is probally not
that hard, I just can't seem to grasp the answer right now.

Thanks,
Ryan




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

Предыдущее
От: Dan Langille
Дата:
Сообщение: Re: extending ORDER BY make query much slower
Следующее
От: Franco Bruno Borghesi
Дата:
Сообщение: What's wrong with this group by clause?