Function which gives back the nearest neighbours of a requested value

Поиск
Список
Период
Сортировка
От Virgile Beddok
Тема Function which gives back the nearest neighbours of a requested value
Дата
Msg-id 2657.146.140.8.144.1111775776.squirrel@webmail.igd.fraunhofer.de
обсуждение исходный текст
Ответы Re: [pgsql-advocacy] Function which gives back the nearest neighbours  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-admin
Hi!

I'm looking for an existing function which allows me to search the nearest
neighbours of the requested value.

A simple example: if I search the value "2", and my table doesn't contain
it, but only contains "0" and "10", as "nearest neighbours", then it will
give me back these values : "0" and "10".
Could you please tell me if such function already exists in Postgresql,
for  one-dimensional objects, and also for multi-dimensional objects.

Thanks a lot in advance.
Virgile Beddok

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

Предыдущее
От: Rigmor Ukuhe
Дата:
Сообщение: Migrating from 7.2 to 8
Следующее
От: "Dr. Roger Wießner"
Дата:
Сообщение: PostgreSQL: ´GRANT ALL TO PUBLIC´ ?