Hello,
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.
This makes it a bit confusing if you have another index like:
create index idx_foo_2 on foo(bar);
Which will show two identical index definitions even though they are
different.
I tested this with PG 8.1 and the 8.1 build 404 driver on Windows 2000
Regards
Thomas