Postgres Pro
Downloads
Home   >   mailing lists

can I index a field of type "point"? - Mailing list pgsql-sql

From Mark Stosberg
Subject can I index a field of type "point"?
Date
Msg-id 388B9E44.F3378DDE@summersault.com
Whole thread Raw
Responses Re: [SQL] can I index a field of type "point"?  ("Gene Selkov, Jr." <selkovjr@mcs.anl.gov>)
List pgsql-sql
Tree view 
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:

Previous
From:
Date:
Subject: Re: [SQL] Join-Question
Next
From: "Gene Selkov, Jr."
Date:
Subject: Re: [SQL] can I index a field of type "point"?