nearest match

From: "Ryan" <pgsql-sql(at)seahat(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: nearest match
Date: 2003-03-12 21:32:32
Message-ID: 10112.65.102.128.233.1047504752.squirrel@fordparts.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2003-03-12 21:36:56 Re: Using column alias in WHERE clause?
Previous Message Valerie Goodman 2003-03-12 21:12:07 "hide" values in a column