Re: getIndexInfo() not returning operator classes

Kris Jurka wrote on 10.11.2005 08:00:
>> when I call getIndexInfo() it correctly returns the definition for
>> function based indexes, but it does not return operator classed.
>>
>> An index: create index idx_foo on foo(bar varchar_pattern_ops);
>>
>> will show up as "bar" only in the definition column of the result set.
>
>
> I'm not sure where you'd like to see the opclass displayed in the
> results of getIndexInfo. Also consider that every indexed column has a
> opclass, the default or a user specified one.
>

for the above mentioned index, I would expect the "DEFINITION" field of
the result set to contain "bar varchar_pattern_ops". Unless I
misunderstood the operator class and it does not apply to a column but
to the whole index. In that case, yes there isn't an apropriate place to
put this information.

Thanks for your answer
Thomas