Hi, and thanks for your input, > Tha said, the replacement string in some editors (like Vim) and some > programming languages (like Perl) provides syntax for changing case > (both vi(m) and Perl use \u and \U...\E for uppercasing). This is probably why I was so frustrated - I thought that there should be an equivalent in PostgreSQL. I was going mad trying all of these from my searches. > > I know about the UPPER() and LOWER() functions and they are not what I want. > Can you elaborate why you can't use those? I want to index on a REGEXP_REPLACE() - I thought using lower -> upper would be a good test. I could always have used another REGEXP_REPLACE() for my testing, but I then became "obsessed" with the idea of using REGEXP_REPLACE() as a substitute for UPPER() - kind of an obfuscated code competition with myself! :-) Again, thanks for your input. E. > hp
