From: | Thomas Kellerer <spam_eater(at)gmx(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: getIndexInfo() not returning operator classes |
Date: | 2005-11-10 18:03:10 |
Message-ID: | dl020t$njm$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2005-11-10 18:39:02 | Re: getIndexInfo() not returning operator classes |
Previous Message | Kris Jurka | 2005-11-10 17:48:31 | Re: getIndexInfo() not returning operator classes |