Kris Jurka wrote on 10.11.2005 18:48:
>> 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.
>>
>
> Opclasses are per column, not for the whole index. I don't see any
> DEFINITION column though.
>
>
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getIndexInfo(java.lang.String,%20java.lang.String,%20java.lang.String,%20boolean,%20boolean)
>
Sorry, I meant COLUMN_NAME (internally I'm collecting all values from
COLUMN_NAME into a field definition, that's where the error comes from).
That column will e.g. contain something like "lower(name)" for a
function based index, so I don't see a reason why it couldn't contain
"bar varchar_pattern_ops"
In both cases it's not the column's name any longer
Regards
Thomas