Re: DatabaseMetaData.getIndexInfo and function-based indexes

Поиск
Список
Период
Сортировка
От peter royal
Тема Re: DatabaseMetaData.getIndexInfo and function-based indexes
Дата
Msg-id 46E72C0A-85C1-11D9-8AAF-000A95AC787E@pace2020.com
обсуждение исходный текст
Ответ на Re: DatabaseMetaData.getIndexInfo and function-based indexes  (Kris Jurka <books@ejurka.com>)
Ответы Re: DatabaseMetaData.getIndexInfo and function-based indexes  (Kris Jurka <books@ejurka.com>)
Re: DatabaseMetaData.getIndexInfo and function-based indexes  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
On Feb 19, 2005, at 2:27 PM, Kris Jurka wrote:
> On Sat, 19 Feb 2005, peter royal wrote:
>
>> i'm mainly concerned about single-column functional indexes right now.
>> being able to get upper(a) as the column name would be enough now. but
>> tom's method for working with multi-column functional indices would be
>> a bonus too.
>>
>> would a patch to have DMD.getIndexInfo() return this information be
>> accepted into the tree? if so, i'll work one up.
>
>
> Yes, a column name of "pg_expression_N" is rather useless.  upper(a)
> may
> not be a column name, but it is more accurate and informative.

Patch + test cases attached.
-pete


Вложения

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Guillaume Cottenceau
Дата:
Сообщение: PGStatement#setUseServerPrepare breaking PreparedStatement#executeUpdate return value?
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: [postgis-devel] JDBC & WKB - 400% overhead