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
