Re: Creating index with upper function

bozon wrote: > On Feb 2, 7:24 pm, Fernando Nunes <domusonl...@gmail.com> wrote: >> bozon wrote: >>> Here is another tidbit from the manual: >>> The function must be a user-defined function. You cannot create a >>> functional index on any built-in function of SQL. You can, however, >>> create a functional index on a user-defined function that calls a >>> built in function and uses the value returned by the built-in function >>> as the index key of a functional index. >> There are references to this subject way back to 1999 :) >> Apparently the fact is that it doesn't support the usage of built in functions. >> There is a feature request to change that. I believe the manual reference you >> mention was a fix into 11.10 docs. >> >> The error can be misleading... The issue may be the fact that UPPER is builtin >> and not the fact that it's variant or non-variant. >> >> -- >> Fernando Nunes >> Portugal >> >> http://informix-technology.blogspot.com >> My email works... but I don't check it frequently... > > I was looking at 11.50 documentation. I should have mentioned that in > the citation. What I meant is that the clarification that we cannot use internal/builtin functions was introduced in 11.10. So it's normal they're still on 11.50. We could compare it with V10 or before. Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...