can I index a field of type "point"?

From: Mark Stosberg <mark(at)summersault(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: can I index a field of type "point"?
Date: 2000-01-24 00:36:07
Message-ID: 388B9E44.F3378DDE@summersault.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hello!

Is there a way to index a point field? The obvious method didn't work
for me:
mark=> create index lon_lat_idx on zip (lon_lat);
ERROR: Can't find a default operator class for type 600

I'm using Postgres v 6.5.3

Thanks,

-mark

<<-------------------------------------------------------------->>
personal website < Summersault Website Design
http://mark.stosberg.com/ > http://www.summersault.com/

Browse pgsql-sql by date

  From Date Subject
Next Message Gene Selkov, Jr. 2000-01-24 02:24:48 Re: [SQL] can I index a field of type "point"?
Previous Message Borek.Lupomesky 2000-01-23 22:38:17 Re: [SQL] Join-Question