Re: Index on points

On Tue, Jun 08, 2004 at 14:17:57 +0200,
  Holger Klawitter <lists@klawitter.de> wrote:
>
> Hi there,
>
> which operator class can I use in order to search points by distance like in:
>
> SELECT p FROM tbl WHERE (p <-> point(0,0)) < 10;
>
> - From what I've seen, there is none - which surprises me ...

You want to create a box that includes all points that might match
and use that to do an index search (using an rtree index) and then
check that the distance is really less than whatever.