nearest match - Mailing list pgsql-sql

From Ryan
Subject nearest match
Date
Msg-id 10112.65.102.128.233.1047504752.squirrel@fordparts.com
Whole thread Raw
List 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 by date:

Previous
From: Dan Langille
Date:
Subject: Re: extending ORDER BY make query much slower
Next
From: Franco Bruno Borghesi
Date:
Subject: What's wrong with this group by clause?