|Subject||Re: [firebird-support] Computed index for case insensitive queries|
|Author||Alexandre Benson Smith|
Em 25/8/2014 00:59, Caroline Beltran caroline.d.beltran@... [firebird-support] escreveu:
Mark, thank you for responding. I ended up downloading FlameRobin and it does show computed indexes in the 'Index' tab as well as in the DDL, i.e.:P.S. I found your response in my Google 'Sent' folder, it never made it into my inbox, but anyway, I am glad I located your message.
CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname));
Why not use a case insensitve collation ?
see you !