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-G
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 ind
ABHANG RANE <[EMAIL PROTECTED]> 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
---(end of broadcast)
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
