How to create a spatial index on point data. - Mailing list pgsql-novice

From s anwar
Subject How to create a spatial index on point data.
Date
Msg-id 3e3c86f90708161048g43e7e2eeh8d053a80f431a221@mail.gmail.com
Whole thread Raw
Responses Fwd: How to create a spatial index on point data.
List pgsql-novice
How does once create a spatial index on point data. I did the
following and got the error given below.

create table foo(x point);
create index foo_x on foo using gist(x);
ERROR:  data type point has no default operator class for access method "gist"
HINT:  You must specify an operator class for the index or define a
default operator class for the data type.

Thanks.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: rogue process maxing cpu and unresponsive to signals
Next
From: "s anwar"
Date:
Subject: Fwd: How to create a spatial index on point data.