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.:

CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname));

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.



Why not use a case insensitve collation ?


see you !