Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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/

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group