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: (view raw or whole thread)
Lists: pgsql-sql

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



personal website                <    Summersault Website Design     >

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-2015 The PostgreSQL Global Development Group