Geoff hendrey <[EMAIL PROTECTED]> writes:
> Hi Guys,
>
> I was wondering what is being done for case-insensitive
> comparisons. Also wanted to propose an implementation option, which
> would be to allow indexes to be created on UPPER or LOWER. As long as
> I had an index on UPPER or LOWER, I could
Hi Geoff,
The community has discussed a couple approaches to case-insensitive
search. My favorite is DERBY-418 (generated columns), which pretty much
aligns with what you are proposing. DERBY-481 already has a functional
spec attached to it. With generated columns, you would be able to index
Geoff hendrey wrote:
Hi Guys,
I was wondering what is being done for case-insensitive comparisons.
Also wanted to propose an implementation option, which would be to
allow indexes to be created on UPPER or LOWER. As long as I had an
index on UPPER or LOWER, I could do this efficiently:
WHER
Hi Guys,
I was wondering what is being done for case-insensitive comparisons. Also
wanted to propose an implementation option, which would be to allow indexes to
be created on UPPER or LOWER. As long as I had an index on UPPER or LOWER, I
could do this efficiently:
WHERE UPPER(T1.lastname) = U