From: | "Virgile Beddok" <virgile(dot)beddok(at)igd(dot)fraunhofer(dot)de> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Cc: | pgsql-advocacy(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
Subject: | Function which gives back the nearest neighbours of a requested value |
Date: | 2005-03-25 18:36:16 |
Message-ID: | 2657.146.140.8.144.1111775776.squirrel@webmail.igd.fraunhofer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-advocacy pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Subbiah, Stalin | 2005-03-25 19:12:37 | 64 or 32 postgres |
Previous Message | Lee Wu | 2005-03-25 17:58:24 | Re: explain analyze of PG server level |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2005-03-27 05:24:34 | Re: [pgsql-advocacy] Function which gives back the nearest neighbours |
Previous Message | Guy Flaherty | 2005-03-24 03:59:51 | postgresQL.org "Latest News" or "Latest Product"? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-03-25 19:45:01 | Re: outputting everything from psql to a file |
Previous Message | Walker, Jed S | 2005-03-25 17:39:02 | outputting everything from psql to a file |