db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Williamson, Nick" <nick_william...@mentor.com>
Subject Function-based indexes
Date Tue, 14 Aug 2007 10:40:29 GMT
Hi all,

In Oracle, it's possible to have an index column that is the result of a
function, for example:

CREATE INDEX index_name ON table_name
  (
    UPPER("column_name")
  );

It doesn't seem possible to do this in Derby. What would be the best way
to mimic this behaviour? I guess I would need a new column to hold the
uppercased value of the original column, but can I get Derby to maintain
the new column for me, perhaps with a trigger? Or is it possible to have
a column that is itself the result of a function on another column?

TIA
Nick

Mime
View raw message