|Subject||Re: [firebird-support] Case insensitive queries in Firebird 3 ?|
> will there be case insensitive queries that can use an index in Firebird 3 ?In Firebird 2, there will be expression indices available.
> I often see questions about this issue in this newsgroup and now i want
> to know if this problem will be adressed in the next future ?
> I think it would be a very useful feature.
For example, you can create an index like that:
create index idx_customer_fullname_ci on customer computed by
The following query will use the index then:
select * from customer where upper(fullname) = upper('Sparky');
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and