Index on points

From: Holger Klawitter <lists(at)klawitter(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Index on points
Date: 2004-06-08 12:17:57
Message-ID: 200406081418.02820.lists@klawitter.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message btober 2004-06-08 12:18:28 Re: encrypted passwords
Previous Message mike 2004-06-08 11:37:48 problem with inserting a generated seq no into not null field