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 17:30:13 |
Message-ID: | dl0033$hng$1@sea.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2005-11-10 17:48:31 | Re: getIndexInfo() not returning operator classes |
Previous Message | Guillaume Cottenceau | 2005-11-10 16:52:11 | Re: More Verbose Logging of Statements |