Thread: opclass for real[]

Hi,
I have a column real[] in my table. I need to create a gist index on
it. But the error is obvious as follows.

ERROR:  data type real[] 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.

Is there a opclass defined in 8.2 or I have to create one. In either
case can you please give a link for information on opclasses.

Thanks
Abhang

ABHANG RANE <arane@indiana.edu> writes:
> I have a column real[] in my table. I need to create a gist index on
> it.

An index to do what --- ie, what queries do you hope the index will help
with?

            regards, tom lane

On May 29, 2007, at 11:42 , ABHANG RANE wrote:

> I have a column real[] in my table. I need to create a gist index
> on it. But the error is obvious as follows.
>
> ERROR:  data type real[] 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.
>
> Is there a opclass defined in 8.2 or I have to create one. In
> either case can you please give a link for information on opclasses.

I don't believe there's a native GiST opclass for real arrays. Out of
curiosity, what will you be using a GiST index on real arrays for?

Concerning opclasses, have you checked the fine documentation? Just
checking the index provides these two links:

http://www.postgresql.org/docs/8.2/interactive/indexes-opclass.html
http://www.postgresql.org/docs/8.2/interactive/xindex.html#XINDEX-IM

Michael Glaesemann
grzm seespotcode net

> ERROR:  data type real[] 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.
There is operator class for GIN for real[].
http://www.postgresql.org/docs/8.2/static/xindex.html#XINDEX-GIN-ARRAY-STRAT-TABLE

>
> Is there a opclass defined in 8.2 or I have to create one. In either
> case can you please give a link for information on opclasses.
>
> Thanks
> Abhang
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/