DatabaseMetaData.getIndexInfo and function-based indexes

From: peter royal <proyal(at)pace2020(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: DatabaseMetaData.getIndexInfo and function-based indexes
Date: 2005-02-18 22:55:22
Message-ID: 2BDB6E76-8200-11D9-8AAF-000A95AC787E@pace2020.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

say i have an index:

create index my_index on my_Table (upper(my_field) );

it is possible to retrieve the fact that the field is upper(my_field)
via DMD.getIndexInfo() ?

With 7.4 (and the associated JDBC driver) the column name shows up as
pg_expression_1 (or something very close to that :)

... or is this something that is fixed in 8.0?

Thanks.

-pete

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-02-19 04:07:03 Re: DatabaseMetaData.getIndexInfo and function-based indexes
Previous Message John R Pierce 2005-02-18 22:20:13 Re: jdbc and windows