Re: getIndexInfo() not returning operator classes - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: getIndexInfo() not returning operator classes
Date
Msg-id Pine.BSO.4.61.0511100152300.25311@leary.csoft.net
Whole thread Raw
In response to getIndexInfo() not returning operator classes  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: getIndexInfo() not returning operator classes  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-jdbc

On Thu, 10 Nov 2005, Thomas Kellerer wrote:

> 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.

Kris Jurka

pgsql-jdbc by date:

Previous
From: "Srivats"
Date:
Subject: Getting param names
Next
From: Rob Kirkbride
Date:
Subject: More Verbose Logging of Statements