| Subject | Re: [firebird-support] Computed index for case insensitive queries |
|---|---|
| Author | Caroline Beltran |
| Post date | 2014-08-25T03:59:08Z |
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.CREATE INDEX IDX_FNAME ON PEOPLE COMPUTED BY (lower(fname));