Re: Case-Insensitive search

There is new Trigger functionality in 7.3 allowing you to modify the triggering row, which was until now only possible for updates. With this you should at least be able to solve the 'upper' problem with an additional column. And yes, Oracle also does not supply an indexable upper function. Nils Myklebust wrote: > So as UDO is too expensive for our purposes and even 7.3 can't create > indexes using functions we are still left with the need for an extra > field containing the uppercase version of the data. > > Unfortunately you also need UDO to keep such a field updated > automatically. The SPL language is too limited to be able to do it via > a trigger/stored procedure. (May be the new upper function could be > used now, but we need to be able to implement a metaphone funtcion.) > This leaves us having to implement this in every application that > updates the table(s) where this functionality is needed. A real pain. > > As far as I know no competitors of Informix have any better > functionality than what is in 7.3. That is an upper/lower function, > but no indexes using such a function. This leads to sequential scans > as soon as you use the function in a where clause. Totaly unaceptable > to us. <snip>