Index on points - Mailing list pgsql-general

From Holger Klawitter
Subject Index on points
Date
Msg-id 200406081418.02820.lists@klawitter.de
Whole thread Raw
Responses Re: Index on points  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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 ...

Mit freundlichem Gruß / With kind regards
    Holger Klawitter
- --
lists <at> klawitter <dot> de
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQFAxa561Xdt0HKSwgYRAriFAJ4jiNya++OcM8LuQbl/nhhjiKcQywCfeeUj
FuMLsNgpOR0totwbDfp68SM=
=R1om
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From:
Date:
Subject: Re: encrypted passwords
Next
From: Jan Wieck
Date:
Subject: Re: The pgreplication project