Type POINT and index

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Type POINT and index
Date: 2001-12-06 15:25:52
Message-ID: 003801c17e6a$4adfd220$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

I made this little talbe:
CREATE TABLE location (
loc_id SERIAL PRIMARY KEY,
cordinata POINT NOT NULL
);

I want to index the column "cordinata" with "RTREE" so I can scan it fast
and find easily distance or other GIS information.

When I try to index the column it keep asking me about operator, which
should I choose ?

I need thing like: select all other coordinates that are in Radius of 100
units.

Is it possible ?

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Tim Barnard 2001-12-06 15:51:42 Re: C interface libpq.so.2 problem
Previous Message Colm McCartan 2001-12-06 15:18:49 Re: Two very basic questions..