Re: getIndexInfo() not returning operator classes

Поиск
Список
Период
Сортировка
Искать
От
Kris Jurka
Тема
Re: getIndexInfo() not returning operator classes
Дата
Msg-id
Pine.BSO.4.61.0511100152300.25311@leary.csoft.net
Ответ на
Список
Дерево обсуждения
getIndexInfo() not returning operator classes Thomas Kellerer <spam_eater@gmx.net>
Re: getIndexInfo() not returning operator classes Kris Jurka <books@ejurka.com>
Re: getIndexInfo() not returning operator classes Thomas Kellerer <spam_eater@gmx.net>
Re: getIndexInfo() not returning operator classes Kris Jurka <books@ejurka.com>
Re: getIndexInfo() not returning operator classes Thomas Kellerer <spam_eater@gmx.net>
Re: getIndexInfo() not returning operator classes Kris Jurka <books@ejurka.com>
Re: getIndexInfo() not returning operator classes Tom Lane <tgl@sss.pgh.pa.us>
Re: getIndexInfo() not returning operator classes Thomas Kellerer <spam_eater@gmx.net>


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 по дате отправления
От: Srivats
Дата:
Сообщение: Getting param names
От: Rob Kirkbride
Дата:
FAQ