Re: Index on points - Mailing list pgsql-general

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

Hi!

> > SELECT p FROM tbl WHERE (p <-> point(0,0)) < 10;
> 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.

Thanks for the hint!
I was just too confused about the lack of point operators to think about
alternatives...

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

iD8DBQFAxc2h1Xdt0HKSwgYRAl47AJ0XF49Mr8OgPSwM5uULTOcp3nGVAgCfWWp9
NBrsrP1Fnu2+UCo63niQzjQ=
=/7qF
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: [HACKERS] The pgreplication project
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] The pgreplication project